Re: Limit on number of columns in an index

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_at_gmail.com> 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 30
> columns.
>
> Thanks

-- 
Riku Räsänen
Kantamestarit OY
riku.rasanen_at_kantamestarit.fi
+358 (0)50 548 0589
--
http://www.freelists.org/webpage/oracle-l