-
We have a table with 5 columns in the index. In the where clause, only the first column of index appears, I want to know why it doesn't use the index but full-scan instead.
Thanks.
Queyon
Queyon Zeng
-
When was the table last analyzed?
What is the SQL in the query?
What is the capitol of Malaysia?
MH
I remember when this place was cool.
-
SQL Query
I have table (C1, C2, C3, C4, C5, C6, C7) with primary key (C1, C2, C3, C4, C5) using index and,
SELECT * FROM table WHERE C1 = 10;
It performs a full table scan even I just analyzed the table and index.
Malaysia.
Thanks.
Queyon
Queyon Zeng
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|