Home » RDBMS Server » Performance Tuning » How can i tune such a simple sql
How can i tune such a simple sql [message #249170] Tue, 03 July 2007 10:02 Go to next message
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
Re: How can i tune such a simple sql [message #249175 is a reply to message #249170] Tue, 03 July 2007 10:07 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
read it for tunning...
http://people.aapt.net.au/roxsco/tuning/
Re: How can i tune such a simple sql [message #249182 is a reply to message #249175] Tue, 03 July 2007 10:30 Go to previous messageGo to next message
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
Re: How can i tune such a simple sql [message #249189 is a reply to message #249182] Tue, 03 July 2007 10:45 Go to previous message
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
Previous Topic: gather_statistics
Next Topic: Performance Problem
Goto Forum:
  


Current Time: Fri Dec 09 19:45:26 CST 2016

Total time taken to generate the page: 0.08186 seconds