In short, it changes the way you should think of concatenated indexes, ie you should put the least selective column first, then compress it. That way you'll end up with very small indexes compared to the old days and ways.
I don't see any drawbacks to this approach except that you of course has to unlearn what you have learned (Yoda?)...
Other index things Jonathan adresses include: It is actually better to index small tables, even one-row tables.
Mogens
Rachel Carmichael wrote:
http://www.tusc.com/oracle/download/author.html#loneyk--- John Kanagaraj <[EMAIL PROTECTED]> wrote:Mark,Also, I have heard about compressing indexes, but it is something I have never used before. Can anyone shed some light on the topic? Are there any drawbacks (ie: reduced IO but increased processing)?Kevin Loney presented a paper on this at IOUG 2002 - should be in the archives at www.ioug.org. John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).__________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com
