database
i have fifty lakh record in my database how to search a specific person?
and if i use select query then it take lot of time,,, Any method to
solve this problem...
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Mar 28, 2013, 11:49 PM
hi,
to make seach fast, create index on columns which are used with where clause
for example if you are seach data by name than you may create non clustered index on this column, this make search fast.
SELECT * Product
WITH(INDEX(INX_ProductName))
WHERE ProductName = 'Processor';
you may also use filtered index if it is fit on your requirement.
http://www.codeproject.com/Articles/22853/SQL-Server-Performance-Tips-and-Guidelines
hope this will help you.
Vishal GilbilePosted Mar 28, 2013, 6:02 AM
You will have to make use of Query Optimization methods such as Indexing or Partitioning of Table.
Hope that helps you.
With Regards,
Vishal Gilbile.
Arul ManivannanPosted Mar 28, 2013, 5:44 AM