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:


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


Riku Räsänen
Kantamestarit OY
+358 (0)50 548 0589

Other related posts: