Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Index compression on Oracle 9.2

Re: Index compression on Oracle 9.2

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Tue, 31 Jan 2006 10:33:28 -0500
Message-ID: <BAY103-DAV58EAAAE0291C1DF16B38AA6080@phx.gbl>


Your indexes must be pretty unique as they are the same size as your table. Are the first few columns in the index repeatable? Did you try it out on a subset of data?

Mike

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 31 2006 - 09:33:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US