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!

How index Works.

Manu.Sep 10 2009 — edited Sep 10 2009

Hi all,

Shall i know how the indexes work internally in Oracle database. Because when we are creating index in some fields, its slows down the speed of the query, and when creating some indexes speeds up the index.

So please help me How to determine the fields, in which i have to create index and in what basis.

Thanks and Regards,

Manu.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 8 2009

Added on Sep 10 2009

#general-database-discussions

4 comments

528 views