Link to home
Start Free TrialLog in
Avatar of bibi92
bibi92Flag for France

asked on

Datas and index same Space usage

Hello

How can I reduce index size if used same Space usage or data?

Thanks

Regards
Avatar of JesterToo
JesterToo
Flag of United States of America image

Do the columns that are being indexed contain the bulk of information of a row and do they tend to be relatively unique?  If so, that could result in index space usage approaching the size of the data space.
if you delete all data in table, index size will be 0 :)
index is actually a table with pointer + columns in index...
so, the size depends on underlying table and the size of columns involved in the index...
Avatar of Jim Horn
Not sure what you mean by 'used same Space usage or data', please explain this.
Avatar of bibi92

ASKER

50% datas and 50% indexes
Thanks
>50% datas and 50% indexes
Okay, I'll bite.  Why's that?  If your indexes are as large as your table data, then what's the point of having indexes, as they are just as efficient as searching the data?

Please script out your create table statement, with indexes, and paste it into this question.
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bibi92

ASKER

Thanks regards