What is the excution order in Query like:
SELECT * FROM [users] WHERE [userid] = 50001 AND [username] = 'new user'
My question is what will be matched for first - [userid] or [username].
and so will affect the execution time.
Any suggesetion to improve this query will be appriciated.