According to 10.2 Concepts-manual:"No more than 32 columns can form a regular composite index. For a bitmap index, the maximum number columns is 30. A key value cannot exceed roughly half (minus some overhead) the available data space in a data block."
On Wed, 19 Mar 2008 19:58:52 +0200, Ram Raman <veeeraman@xxxxxxxxx> wrote:
Listers,Is there any limit on the number of columns a BTree index can have, before it is considered a bad design. I see a need to build an index with almost 30columns. Thanks
-- Riku Räsänen Kantamestarit OY riku.rasanen@xxxxxxxxxxxxxxxx +358 (0)50 548 0589 -- http://www.freelists.org/webpage/oracle-l