It's also worth noting that since TK originally
published it, Oracle 8.1 has increased the limit
on indexes to 32 columns (or 30 for bitmaps),
from 16, so the code has to be adjusted
accordingly - not that many people will have
32 column keys I suspect.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Mark D Powell wrote in message
<011f9940.e63d7028_at_usw-ex0102-015.remarq.com>...
>I believe that the author of the SQL in question was Thomas Kyte
>as he posted that SQL on July 24, 1998. I know as I copied it
>and have reposted a slightly modified version which shows the
>index_name when it exists and reformats for 80 columns output.
>
>
>-----------------------------------------------------------
>
>Got questions? Get answers over the phone at Keen.com.
>Up to 100 minutes free!
>http://www.keen.com
>
Received on Mon Jul 24 2000 - 00:00:00 CDT
