Index creation status

deshaipet · #1 (**permalink**) 02-09-12, 17:29

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

sathyaram_s · #2 (**permalink**) 02-09-12, 18:22

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.

=

deshaipet · #3 (**permalink**) 02-10-12, 12:31

Yes Sathya, I would like see how far the index was created.

THanks,

sathyaram_s · #4 (**permalink**) 02-10-12, 15:46

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

deshaipet · #5 (**permalink**) 02-10-12, 15:47

Thanks Sathya

Internet Services

Web Development

Digital Marketing

Consumer Tech