i choose to create indexes in a specific segment
which have 200Mb size.
1) when i compute the size of each indexes, i find 9411 pages (2Kb) , So near 20mb
2) so i have dump the transaction.
3) even if i drop all this indexes, the used space decreased but is near 170Mb.
How can this problem appear?
Is there other 'object' which used this segment?
Is Sybase Central giving false information
How can i really know the used and free space?
which have 200Mb size.
1) when i compute the size of each indexes, i find 9411 pages (2Kb) , So near 20mb
2) so i have dump the transaction.
3) even if i drop all this indexes, the used space decreased but is near 170Mb.
How can this problem appear?
Is there other 'object' which used this segment?
Is Sybase Central giving false information
How can i really know the used and free space?