• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

RE: XE : Problems on Table Design Aid with an index more than

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
 
Top