Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2008
    Posts
    76

    Unanswered: Index creation status

    FOlks, Is there any way to find the status of the index creation ?
    Thanks,
    idb2dba

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    What do you mean by status? How far the index creation has progressed?

    The closest you can do is to check the number of rows read/written by the temp table (using table snapshot) against the total number of rows in the table.

    =
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Aug 2008
    Posts
    76
    Yes Sathya, I would like see how far the index was created.

    THanks,
    Thanks,
    idb2dba

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    The best you can do is to check the number of rows read/written by the temp table (using table snapshot) against the total number of rows in the table.

    This is an estimate only
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Aug 2008
    Posts
    76
    Thanks Sathya
    Thanks,
    idb2dba

Posting Permissions

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