Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

index coalesce

668822Dec 18 2008 — edited Dec 19 2008
hi masters.,

this is egarding index management. i am facing the problem regarding one sql query with union and order by clause.


when i remove order by clause, the query runs faster,than with order by clause.

is this the problem regarding index????

i know that indexes rarely need rebuild,thats why i am thinking of coalesce.is this the right decision??

what may be the problem else????

i am using oracle 9i. and i dont have statpack report coz the client is offshore.\

thanks and regards
VD
This post has been answered by Aman.... on Dec 19 2008
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 16 2009
Added on Dec 18 2008
#general-database-discussions, #index
5 comments
655 views