does reorg rebuil a table ... reorg index too ?

labigre · #1 (**permalink**) 06-24-04, 09:29

hi all,

i'm on Sybase 12.5.
i looked on sybooks but nothing is specified ..

when i perform a reorg rebuild on table (datapages or datarows chain ) .. without specify an index name does it regorg index too ? for clustered and non clustered index ?

how can i see instex clusterisation ?

thnx for any help .

Labigre

err1 · #2 (**permalink**) 06-24-04, 11:47

yes, 'reorg rebuild yourTable' rebuilds yourTable, refreshes all its indexes and updates its statistics.

err1

labigre · #3 (**permalink**) 06-24-04, 13:19

oki thnx Err1 .

and do you know how can i check my index cluster ratio ?

thnx