Re: Max number of columns/indexes?

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Mon, 12 Apr 1999 10:56:54 +0900
Message-ID: <371160F6.4F17@bhp.com.au>

Acorn wrote:
>
> Does anyone know off the top of their heads what the max number of
> columns/indexes are in Oracle 8 or any of it's versions? We're trying to
> decide which n-tier capable dbms to support next, and I'm gathering specs on
> Oracle's products.
>
> Better yet
>
> I'm looking for the answers to these questions:
>
> 1. Max # of columns/indexes
>
> 2. Max database size
>
> 3. Max tables per SELECT statement
>
> stuff like that. Could anyone point me in the direction of any stats like
> this?
>
> I sure appreciate your assistance in advance!
> Conrad

(I think)

16 columns per index in 8.0 and below
32 columns per index in 8.1 (8i)
--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"Never wrestle a pig - you both get dirty and the pig likes it..." Received on Sun Apr 11 1999 - 20:56:54 CDT