OraFAQ Forum: Performance Tuning » how to avoid the full table scan?

Home » RDBMS Server » Performance Tuning » how to avoid the full table scan?

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

how to avoid the full table scan? [message #123430]

Mon, 13 June 2005 07:59

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...

Report message to a moderator

Re: how to avoid the full table scan? [message #123438 is a reply to message #123430]

Mon, 13 June 2005 08:33

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: how to avoid the full table scan? [message #124411 is a reply to message #123430]

Sat, 18 June 2005 03:56

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 18 08:08:40 CDT 2025