RE: Limit on number of columns in an index
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "veeeraman@xxxxxxxxx" <veeeraman@xxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 Mar 2008 14:19:11 -0400
Well, as with all things, there's no hard rule...but 30 does seem like a
lot.....
How many total columns in the base table? Have you considered making the table
an IOT instead?
-Mark
--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059
mark.bobak@xxxxxxxxxxxxxxx<mailto:mark.bobak@xxxxxxxxxxxxxxx>
www.proquest.com<http://www.proquest.com>
www.csa.com<http://www.csa.com>
ProQuest...Start here.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Ram Raman
Sent: Wednesday, March 19, 2008 1:59 PM
To: oracle-l
Subject: Limit on number of columns in an index
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
Other related posts:
