SQL Server - Fast searching Data from Database
Asked By ALOK RANJAN on 21-Jun-12 05:37 AM
I have a table in sqlserver database which contains 15,00000( 1.5 crore record )
and field are Registration No,CSC Code,Physical Code now I want to search record according to Registration number but when we enter Reg No. It take too much time to find that particular record .now I want quick result from database how it possible .
Thanks & Best Regards