Three-Star Oracle Indexes and Three-Star Oracle Conferences
Dear NoCOUG Members and Friends,
Oracle indexes can be given one, two, or three stars. A three-star index is the best possible index for a SQL query.
- The first star is given if the index entries relevant to the query are next to each other or at least as close to each other as possible. This minimizes the thickness of the index slice that must be scanned.
- The second star is given if the index rows are in the right order for the query. This eliminates sorting.
- The third star is given if the index rows contain all the columns referred to by the query. This eliminates table access: the access path is index-only.
You can read more about three-star indexes in Relational Database Index Design by Lahdenmaki and Leach which is #1 on the top-ten list of Oracle books recommended by Oracle performance expert Jonathan Lewis in his interview titled Everybody Loves Jonathan printed in the November 2008 issue of the NoCOUG Journal.
Similarly, Oracle conferences can be given one, two, or three stars.🙂 A three-star conference is the best possible conference you can imagine.
- The first star is given for great speakers.
- The second star is given for a great location.
- The third star is given for a great occasion.
NoCOUG Conference #100 Sponsored by Quest Software—Simplicity at Work on Wednesday, November 9 is a three-star conference.
- It will feature some of the best speakers in the world including Oracle ACE Directors Steven Feuerstein , Craig Shallahamer , and Alex Gorbachev .
- It will be held at the greatest location in the world for an Oracle conference—the Computer History Museum in Mountain View. The museum features wonderful computing artifacts including Hollerith’s 1890 Census Tabulator—the product that made IBM famous—and a Babbage Difference Engine—one of only two that have ever been constructed.
- It is a history-making occasion. NoCOUG is celebrating its 25th anniversary in 2011 and the upcoming conference is NoCOUG’s 100th quarterly conference.
Conference 100 will be our biggest, baddest conference ever! Don’t you want to be there? We’ve opened registration early because we expect so many attendees. Please review the agenda and RSVP right away.
Dave Abercrombie, Journal Editor
Eric Hutchinson, Webmaster
Gwen Shapira, Conference Director
Hanan Hit, Vice President
Iggy Fernandez, President
Jen Hong, Board Member at Large
Naren Nagtode, Secretary and Treasurer
Omar Anwar, Vendor Coordinator
Randy Samberg, Training Coordinator
Scott Alexander, Speaker Coordinator