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='PRAVIN@GMAIL.COM' (Note: EmailID is not primary key or clustered index or non clustered index). Please guide me so that i can improve the query performance.

Also you can create non cluster index on emailId column that boost up query performance. create non cluster index column those are used in where clause or join. hope this will help you.

CREATE NONCLUSTERED INDEX [IX_DeliveryEmailID] ON [dbo] . Delivery ( [EmailID] ASC ) set Nocount On Select coulmn1 , column2 from Delivery(nolock) where Emailid = 'Pravin@gmail.com'

Thanx to all for your replies. Problem has been resolved by adding non clustered index

hi friend write query as replace field name on * SELECT fieldname FROM DELIVERY WHERE EMAILId='PRAVIN@GMAIL.COM' retrive that values which are you needed so if write this kind of query then get much faster data fetching

Answers

SQL Query taking too much time to fetch single data

Pravin Ghadge

11y

1.9k

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.