Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Unanswered: recreate bad indexes

    IDS 9.21
    Linux 7.3

    I have a table with 4 000 000 rows.
    This table change very often(5 rows per second).
    This table has bad indexes. How can I recreate indexes on modifying table.
    Clients must work with this table during creating indexes.

  2. #2
    Join Date
    Jan 2005
    Unfortunately you need exclusive access to a table to create an index. So no-one can even be selecting from the table when you create the indexes. You would really have to schedule some down time, and then do your index work.

Posting Permissions

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