SQL Tuning
From: Velu Natarajan <nvelu_78_at_rediffmail.com>
Date: Fri, 30 May 2003 11:24:21 +0000
Message-ID: <2939700.1054293861_at_dbforums.com>
Date: Fri, 30 May 2003 11:24:21 +0000
Message-ID: <2939700.1054293861_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.com
Received on Fri May 30 2003 - 13:24:21 CEST