bibi92
asked on
Datas and index same Space usage
Hello
How can I reduce index size if used same Space usage or data?
Thanks
Regards
How can I reduce index size if used same Space usage or data?
Thanks
Regards
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...
so, the size depends on underlying table and the size of columns involved in the index...
Not sure what you mean by 'used same Space usage or data', please explain this.
ASKER
50% datas and 50% indexes
Thanks
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks regards