 |
Will index on a date column help in enhancing query performance in oracle? |
[Edit] |
Answer
If you are going to use the date column in the WHERE clause of you select, THEN Indexing on that date column will enhance the performance
Hope this helps
First answer by Rohiniskumar. Last edit by Rohiniskumar. Contributor trust: 121 [recommend contributor]. Question popularity: 11 [recommend question]
|
Research your answer: |
Can you answer other
questions about databases and data management systems?
Answers.com > Wiki Answers > Categories > Technology > Computers > Computer Databases > Will index on a date column help in enhancing query performance in oracle?
Our contributors said this page should be displayed for the questions below. (Where do these come from ) |
| If any of these are not a genuine rephrasing of the question, please help out and edit these alternates. |
How do you tune a query in oracle?
