Re: SQL Tuning

To retrieve 10 million records in under 6 seconds seems pretty reasonable. Again post explain plan and tkprof , give version. Also what fetch size are you using? How are you retrieving? You are rather vague on details. 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:2942971.1054354818_at_dbforums.com...


>

> 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