| Full table scan when one type of records [message #377530] |
Tue, 23 December 2008 06:27  |
senaka
Messages: 5
Registered: September 2008
|
Junior Member |
|
|
When I execute the following query in the table, the explain plan shows a full table scan.
SELECT *
FROM Posting_Proposal_Head_Tab.
WHERE COMPANY = '01'
Company field is part of the primary_key.
table holds records only on company '01'.
When I used a company which is not exist in the table(other than '01') then shows a index range scan.
Is this a bug in oracle or is this the way that the query should handle.
|
|
|
|
| Re: Full table scan when one type of records [message #377538 is a reply to message #377530] |
Tue, 23 December 2008 06:48  |
 |
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
Oracle is very smart.
It knows that if you use 01 then it has to return (almost) all rows so it knows it is faster to full scan.
And it knows when you use another value there is no or few rows so it uses index.
Really smart, doesn't it?
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
