Home » RDBMS Server » Performance Tuning » how to avoid the full table scan?
how to avoid the full table scan? [message #123430] Mon, 13 June 2005 07:59 Go to next message
confident
Messages: 28
Registered: March 2005
Junior Member
well, iam not so good in sql tunning,i need to tune the some queries, urgently.. can anybody pls tell me how to avoid the full table scan in sql query..
what are hints are used to avoid the full table scan in query...
Re: how to avoid the full table scan? [message #123438 is a reply to message #123430] Mon, 13 June 2005 08:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
FTS ( full table scan) is NOT always bad.
If your query is pulls out too many rows, the CBO decides that instead of using the index, it may be cheaper NOT TO use the index.
So leave this option to CBO.
create the proper index.
Analyze the tables/indexes.
Let the CBO do the job.
Re: how to avoid the full table scan? [message #124411 is a reply to message #123430] Sat, 18 June 2005 03:56 Go to previous message
srraajesh
Messages: 63
Registered: May 2005
Member
This link has an interesting discussion

http://asktom.oracle.com/pls/ask/f?p=4950:8:9852392281001600998::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:9422487749968

Previous Topic: VERY URGENT -- SQL- TUNING
Next Topic: choosing the right query
Goto Forum:
  


Current Time: Thu Mar 28 12:11:46 CDT 2024