Database Administration (MOSC)

MOSC Banner

Sort by date field

edited Apr 15, 2013 10:26PM in Database Administration (MOSC) 4 commentsAnswered
I have developers asking why is the query select * from table_name order by date; running so slow. I looked at the table. The table has three indexes, but date field is not in any of the three indexes. My question is if the date field is not indexes will the query be doing full table scan even though there are indexes on id field? Another question is, will it be a good idea to index the date field? Please advise. Thank you very much.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center