epost
Active Member
RE: XE : Problems on Table Design Aid with an index more than
Are you creating the index or is it already on the table. An index with
that many columns is rarely required in a database unless the amount of
records you have in the table has an unbelievable low level of cardinatality
on say 4, 5 or even 6 columns which would be very strange. Also (at least
for Oracle) the more columns in the index the slower inserts will take place
if it is a table with inserts because is is going to require more blocks in
the index.
Regards,
Ethan Post
Oracle DBA
Are you creating the index or is it already on the table. An index with
that many columns is rarely required in a database unless the amount of
records you have in the table has an unbelievable low level of cardinatality
on say 4, 5 or even 6 columns which would be very strange. Also (at least
for Oracle) the more columns in the index the slower inserts will take place
if it is a table with inserts because is is going to require more blocks in
the index.
Regards,
Ethan Post
Oracle DBA
