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!

Differences between function based index and normal index

532815Jan 30 2007 — edited Jan 30 2007

Hi,

Please Give me some differences between function based index and normal indexes.

1. Is there any performance gain in function based index?
2. Why indexes created in DESC are treated as function based?
3. Every DESC index is b-tree index?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 27 2007

Added on Jan 30 2007

#general-database-discussions

2 comments

1,241 views