Order By and Use Index

Hi all, I have a table like that table1: field1 field2 . . . where : field1,field2 is the primary key. When I make this query: SELECT * FROM table1 USE INDEX(PRIMARY) I get a different result, if I make this: SELECT * FROM table1 ORDER BY field1,field2 Why? Is not

Order By and Use Index

Javier, Tuesday, March 12, 2002, 3:04:21 PM, you wrote: J I have a table like that J table1: J field1 J field2 J . J . J . J where : J field1,field2 J is the primary key. J When I make this query: J SELECT * FROM table1 USE INDEX(PRIMARY) J I get a different result, if