Home > Announcements, DBA, NoCOUG, Oracle, Physical Database Design > Three-Star Oracle Indexes and Three-Star Oracle Conferences

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.

Kindest regards,

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

  1. Mani Kumar Manda
    October 15, 2011 at 3:42 pm

    Nice job Iggy for NoCOUG.
    -Mani

  1. September 17, 2014 at 1:46 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: