Re: SQL Tuning

No Sir, it gets me the first record with in 2 seconds but to get the complete recordset it takes 5.8 seconds.

Originally posted by Jim Kennedy
> 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" wrote in message
> news:2939700.1054293861_at_dbforums.com"]news:2939700.1054293861_at_d-
> bforums.com[/url]...
> > 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/http://dbforums.com     

--
HTML


Posted via http://dbforums.com