OraFAQ Forum: Performance Tuning » How can i tune such a simple sql

Home » RDBMS Server » Performance Tuning » How can i tune such a simple sql

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can i tune such a simple sql [message #249170]

Tue, 03 July 2007 10:02

member1975
Messages: 2
Registered: July 2007

Junior Member

select * from tab where col1 = 'abc'

This takes some 10-15 sec to execute. Do full table scan although there is a index on col1. The table has approx 500,000 records and 40 columns.

col1 is vachar2(250)
Please advice what can i do to speed this up.

Regards

Report message to a moderator

Re: How can i tune such a simple sql [message #249175 is a reply to message #249170]

Tue, 03 July 2007 10:07

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

read it for tunning...
http://people.aapt.net.au/roxsco/tuning/

Report message to a moderator

Re: How can i tune such a simple sql [message #249182 is a reply to message #249175]

Tue, 03 July 2007 10:30

member1975
Messages: 2
Registered: July 2007

Junior Member

Thanks.

It looks after analyzing the table it stated using index.
Don't know why - i am reading

Report message to a moderator

Re: How can i tune such a simple sql [message #249189 is a reply to message #249182]

Tue, 03 July 2007 10:45

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Quote:

Don't know why - i am reading

reading is good for increasing knowledge Wink

Wink

Report message to a moderator

Previous Topic:	gather_statistics
Next Topic:	Performance Problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 08:31:44 CST 2024