database

Question

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...

Jignesh Trivedi · Answer

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 Gilbile · Answer

Hello Friend 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 Manivannan · Answer

Hi Use Select * from tablename with (nolock) or Apply indexing to the column. 50 Lakhs records is huge like anything so taking time is inevitable regards Arul Manivannan