TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Mayur Gujrathi
368
4.1k
1m
SQL query execution timings
Aug 4 2016 8:28 AM
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
Reply
Answers (
5
)
query to search related data in database
Why do not restore the differential backup file?