RE: Limit on number of columns in an index

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_at_il.proquest.com<mailto:mark.bobak_at_il.proquest.com> www.proquest.com<http://www.proquest.com> www.csa.com<http://www.csa.com>

ProQuest...Start here.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Mar 19 2008 - 13:19:11 CDT