Re: Hundreds of columns, index on all of those.

rock_sand81@[EMAIL PROTECTED]
 wrote:

> Topic: Hundreds of columns,

To what purpose?
Is that a data warehouse?

If it is, I suppose you would have told us.
If it isn't, you don't need 900 columns.

> index would be required on all of the columns.

I don't have the docs at hand for other DBs, but postgres sup****ts 32 
indexes per table, mysql 16. Since these limits are way below your 
needs, this means most people don't need as many indexes.

> How could this be implemented?

I would probably go for a hierarchical DB. Since your structure is 
probably heavily de-normalized, it's unlikely you need advanced RDBMS 
features anyway.

Also: are you positively sure you need to retrieve data by any of those 
indexes? What's the cardinality (# of different values) of each of these 
columns, for instance?