Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    17

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

    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

  2. #2
    Join Date
    Jun 2004
    Location
    Paris, France
    Posts
    43
    yes, 'reorg rebuild yourTable' rebuilds yourTable, refreshes all its indexes and updates its statistics.

    err1

  3. #3
    Join Date
    Jun 2004
    Posts
    17
    oki thnx Err1 .

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

    thnx

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •