Tech
Forums
Jobs
Books
Events
Live
Interviews Prep
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
5
Reply
SQL query execution timings
Mayur Gujrathi
Aug 4 2016 8:28 AM
279
Reply
I am not getting the reason why query 1 is taking 10 seconds,query 2 and query 3 taking 1 second to execute even if they are same only order is different
1.SELECT TOP 10000 * FROM tbl1
WHERE
len(empid) = 4 and
isnumeric(empid) = 1 ORDER BY empid desc
2.SELECT TOP 10000 * FROM tbl1
WHERE
len(Employee_ID) = 4 and
isnumeric(empid) = 1
3.SELECT TOP 10000 * FROM tbl1
WHERE
len(empid) = 4 and
isnumeric(empid) = 1 ORDER BY empid
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
5
)
Next Recommended Forum
query to search related data in database
Why do not restore the differential backup file?