Re: Limit on number of columns in an index
- From: Riku Räsänen <riku.rasanen@xxxxxxxxxxxxxxxx>
- To: veeeraman@xxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 Mar 2008 20:55:31 +0200
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 30
columns.
Thanks
--
Riku Räsänen
Kantamestarit OY
riku.rasanen@xxxxxxxxxxxxxxxx
+358 (0)50 548 0589
--
//www.freelists.org/webpage/oracle-l
Other related posts:
