segment

[desert88]

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?

 

[qyllr]

hello,

using isql - The system procedure sp_spaceused reports on the current size of an existing table and any indexes.

here's the syntax:

select
substring(object_name(id) + "." +name, 1,25) Name,
data_pgs(id, doampg) "Data Used",
reserved_pgs(id, doampg) "Data Res",
data_pgs(id, ioampg) "Index Used",
reserved_pgs(id, ioampg) "Index Res"
from sysindexes
where id > 100

if you want the sizes of the indexes to be reported separately, use this command:

sp_spaceused name, 1

(sample output)
index_name size reserved unused
-------------------- ---------- ---------- ----------
name_id_cix 14 KB 1294 KB 38 KB
name_ix 256 KB 272 KB 16 KB
type_price_ix 170 KB 190 KB 20 KB
name rowtotal reserved data index_size unused
------------ -------- -------- ------- ---------- -------
name 5000 1756 KB 1242 KB 440 KB 74 KB

hope this helps,
q.

 

[DBAguy]

you can use isql command:

sp_helpsegment &quot;<your_segment_name>&quot;

this will show which objects are in the segment