Optimizing MySQL queries...

[Darren884]

Would this be slower:

SELECT * FROM `table` WHERE script_id = '$script_id' AND id = '$id'

than

SELECT * FROM `table` WHERE id = '$id'

if

id

was the indexing factor?

[longneck]

the first statement would be faster because your index on id would be used AND you're returning fewer rows.