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.
Loading
Jignesh TrivediPosted Jan 20, 2014, 11:51 PM
create non cluster index column those are used in where clause or join.
hope this will help you.
Pravin GhadgePosted Jan 21, 2014, 12:07 PM
Problem has been resolved by adding non clustered index
Biswa Pujarini MohapatraPosted Jan 21, 2014, 2:55 AM
CREATE NONCLUSTERED INDEX [IX_DeliveryEmailID] ON [dbo].Delivery
(
[EmailID] ASC
)
set Nocount On
Select coulmn1,column2 from Delivery(nolock) where Emailid='[email protected]'
rakesh chaudhariPosted Jan 20, 2014, 10:41 PM
write query as
replace field name on *
SELECT fieldname FROM DELIVERY WHERE EMAILId='[email protected]'
retrive that values which are you needed so if write this kind of query then get much faster data fetching