SQL Server - My table contains more than 10lacs records

Asked By mahesh pandian on 06-Feb-13 06:23 AM

My table contains more than 10lacs records, i need to fetch a single record from the same within a second.

Please help me

thanks in advance

Irbaz Hashmi replied to mahesh pandian on 11-Feb-13 04:15 AM

Create Index on your table columns

mahesh pandian replied to Irbaz Hashmi on 11-Feb-13 04:23 AM

thanks a lot