Re: SQL Tuning
From: Jim Kennedy <kennedy-down_with_spammers_at_attbi.com>
Date: Fri, 30 May 2003 14:35:11 GMT
Message-ID: <z_JBa.53733$_t5.42350_at_rwcrnsc52.ops.asp.att.net>
Date: Fri, 30 May 2003 14:35:11 GMT
Message-ID: <z_JBa.53733$_t5.42350_at_rwcrnsc52.ops.asp.att.net>
version, platform, what is the explain plan and tkprof results. Do you mean it takes 5.8 seconds to get the first record or all records? Jim
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "Velu Natarajan" <nvelu_78_at_rediffmail.com> wrote in message news:2939700.1054293861_at_dbforums.com...Received on Fri May 30 2003 - 16:35:11 CEST
>
> 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