Oracle OpenWorld Unconference Session

Session Title: Oracle Indexes: Tips, Traps and Tit Bits
Presenter: Richard Foote
Time : 2pm
Date : Tuesday 13 November 2007
Location : Moscone West 3rd Floor Overlooks
Room A

Session Description: Ever wanted to know why non-unique indexes are more expensive and costly than unique indexes when policing constraints, why the clustering factor goes crazy when implementing many common Oracle features, why 10g index statistics may no longer be accurate, why deferrable and nonvalidated constraints make some indexes get ignored by the CBO, how to decide when a rebuild is better and less costly than a coalesce (and visa versa), how to index null values and get the CBO to use them, how to not index values in a column, except those that we actually want to search on, how to implement indexed case insensitive searches without having to write function calls in your code, how to index something by using an index that doesn't really exist and lots more interesting things related to Oracle indexes ? If so, then perhaps this presentation may be of interest.

Presenter: Richard Foote has been an Oracle DBA for 12 years, with another 10 years IT experience before that. Based in sunny Canberra, Australia, Richard has been an Oracle OakTable Network member since 2002 and contributes regularly on the comp.database.oracle.server newsgroup and metalink forums.

Related OpenWorld Content: Advanced Index Internals