|
|
Posted by Igor on 05/05/07 10:53
1. Are stored procedures WITH ENCRYPTION slower than the ones without
encryption?
2. Should i put most restrictive conditions first or last in WHERE? In
which order does MSSQL execute conditions? Or MSSQL determents what
would be best and does not bother with the way i sorted conditions?
for example:
SELECT *
FROM [users]
WHERE
[user_id] = 1 AND
[baned] = 0
Is "[user_id] = 1" or "[baned] = 0" going to be executed first?
Navigation:
[Reply to this message]
|