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

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 th