Tech
Forums
Jobs
Books
Events
Videos
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
4
Answers
SQL Query taking too much time to fetch single data
Pravin Ghadge
10y
1.4k
1
Reply
Dear all,
My SQL DB size is 150 GB.
I am fetching record from a simple query but its execution takes too much time (Approx. 1 Min)
My Query is:
SELECT * FROM DELIVERY WHERE EMAILId='
[email protected]
'
(Note: EmailID is not primary key or clustered index or non clustered index).
Please guide me so that i can improve the query performance.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
Query in sql server
Condition in joins