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

On Tue, 6 May 2008 00:05:09 -0700 (PDT), rock_sand81@[EMAIL PROTECTED]
 wrote:

>Topic: Hundreds of columns, index would be required on all of the
>columns.
>
>Hi!
>
>How could this be implemented?
>
>There are several items (or rows).
>
>One item (or row) has e.g. even 900 columns.
>
>An index would be needed on every column.
>
>Would it be better to have 900 columns or should the table structure
>be something else?

The database should definitely be of a different structure. Have a
look at :
http://en.wikipedia.org/wiki/Database_normalization


>
>900 columns, table structure:
>  Item ID, item name, column 1, column 2, column 3, column 4, ...,
>column 888, column 889, column 900
>  -> Index on all of the columns.
>SQL clauses are very long with that kind of a table structure.

This will cause performance problems down the track.

[snip 2 end]