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?



