Re: execution time of a query?
From: Velu Natarajan <nvelu_78_at_rediffmail.com>
Date: Fri, 30 May 2003 11:21:53 +0000
Message-ID: <2939699.1054293713_at_dbforums.com>
Date: Fri, 30 May 2003 11:21:53 +0000
Message-ID: <2939699.1054293713_at_dbforums.com>
Dear Sir/Madam,
I have the Transaction table with 10 Million records. While Tuning the table it takes 5.8 seconds to fetch records from it with Cost based optimization. I have Partitioned my table based on months and necessary index is been created.What should I want to do to reduce this time.
Is there is any way to get the Time duration (like. Estimated Time - 5.8 seconds) taken by a Query in SQL prompt itself.
With Regards
Velu N
-- HTML Posted via http://dbforums.comReceived on Fri May 30 2003 - 13:21:53 CEST