vaishali76
Programmer
i m creating a huge database abour 4TB size.
many tables with many indexes are there. how can i know the index key size using a single query? because i can know the size by adding all the columns size i took to create index, but is there any system table provided using what i can get the key size of all indexes?
Please help... becs i want to assign the dbspace using that information to the indexes.
many tables with many indexes are there. how can i know the index key size using a single query? because i can know the size by adding all the columns size i took to create index, but is there any system table provided using what i can get the key size of all indexes?
Please help... becs i want to assign the dbspace using that information to the indexes.