How do I get how much time left

[Kiran Kumar Pinjala]

Hi
I have a query that is updating about 46 million records, how do I know how
much time is left for the query to complete?

[Tark Siala]

hi
46 million records!!!!
what's system have all these records????
another way you can save time before you run this query, and save time after
run.
then:

time is left for the query to complete = Time After - Time Before
--
Best Regards

Tark M. Siala
Development Manager
INTERNATIONAL COMPUTER CENTER (ICC.Networking)
Khalifa El-Zaydi Street, Madina Building, 1st Floor
Tripoli, Libya
Mobile: [phone]
Tel: [phone]
Fax: [phone]
E-Mail: ***@icc-libya.com
Messenger: ***@hotmail.com
Web Page: http://www.icc-libya.com

Post by Kiran Kumar Pinjala
Hi
I have a query that is updating about 46 million records, how do I know how
much time is left for the query to complete?
--
Thanks
Kiran