I worked with million-plus row tables in Oracle for many years before retiring. Many times the design of the table can beat indexes and other query tricks. Partitioning the table by date can greatly speed up queries limited by date range for example. It can be faster than indexes in many cases. SQL query optimization requires you to know the product (Oracle and version) to do the best job. Sometimes giving the optimizer the hint not to use an index improved performance.
Good article.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
I worked with million-plus row tables in Oracle for many years before retiring. Many times the design of the table can beat indexes and other query tricks. Partitioning the table by date can greatly speed up queries limited by date range for example. It can be faster than indexes in many cases. SQL query optimization requires you to know the product (Oracle and version) to do the best job. Sometimes giving the optimizer the hint not to use an index improved performance.
Good article.