Results 1 to 2 of 2

Thread: reindex script

  1. #1
    Join Date
    Feb 2008
    Posts
    1

    Unanswered: reindex script

    Hi

    Has anyone come across a comprehensive reindex script for sybase apl tables. What I mean by comprehensive - is that it estimates space required and only proceeds if there is adequate space, extracts inex definition of the table and then rebuilds the index.

    Much appreciate any help with this.

    Thanks

  2. #2
    Join Date
    Dec 2007
    Posts
    23
    mmm...
    1st - Calculate free space from DB
    2nd - calculate bigone = (most higger index size from the DB ) * 3
    3rd - if bigone < free space DB
    then
    {
    reindex
    }
    else
    {
    next bigone
    }

    some like this, or i'm drunk yet >_<

    Grtgs

    P.S.: a boot for reindex DB, nice
    There's only 10 kinds of people: the ones who know binary and the ones who doesn't

Posting Permissions

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