Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    The Netherlands
    Posts
    21

    Question Unanswered: Rebuilding indexes

    Hi,

    For normal periodic maintanence, should I rebuilt the indexes each month? Or should I use reorg?

    ASE 12.5.0.1
    Some 6 Gb database (2 Gb data, 4 Gb indexes)

    I have 442 tables with all together some 1200 indexes (clustered and non-clustered) to maintain. Any suggestions?


    Regards,


    D!

  2. #2
    Join Date
    Nov 2003
    Posts
    10

    reorg

    If all your tables are having datarows or datapage level locking, then its better to use reorg otherwise the std drop and re-create index will do.

  3. #3
    Join Date
    Nov 2003
    Location
    The Netherlands
    Posts
    21

    Thanks Hemendra

    I do have all tables in datarow lock scheme. So a reorg can best be used. Thank you very much!

    Greetz,

    Dolphin!

Posting Permissions

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