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

rock_sand81@[EMAIL PROTECTED]
 wrote:

> All of the 900 columns could be on separate rows too.

Oh, I missed this sentence at first.

This gives me a clue about your problem, hence I can say: go for it. 
Trade your columns with rows and you'll be much happier.

> Then creation of an index might be easier. But size of the database
> might increase.

Don't worry about the size of the DB. Less indexes, less space, anyway.