I want to search a record from a database.But this database contains millions of records.So,what should i have to do for search data faster from this database?

Hi, You should create index on table, try to design covering index. For more information please check this article: http://msdn.microsoft.com/en-us/library/ms190806.aspx I hope it helps. J.There are 10 type of people. Those who understand binary and those who do not.

Hi Kavin, 1. Locate MDF and LDF file of the database in different drives as it reduces DISC I/O, hence performance. 2. Try to create Filter based , non clustered and covering index. These are basic things which you should keep in mind while creating database and hence reduces searching time in database, please let me know the more detail of your database so that i will suggest more on the same. Amit Please mark as answer if helpful.

Indexes can only help a Reporting Services query IF you're selecting fewer than (about) 20% of the pages in a data table. If you fetch a single row (unusual for a report) an Index will bring the row to the report processor quickly. If you're fetching all of the information about a particualar entity indexes can help but only to a point. I discuss the SQL Server Query Optimizer in my intermedial webinar series that begins July 12-14th and is held every-other month. See my blog for details.__________________________________________________________________ William Vaughn Author, Mentor, Trainer, MVP Beta V Corporation William Vaughn's blog Hitchhikers Guide to Visual Studio and SQL Server (7th Edition) The Owl Wrangler a fantasy fiction novel Please click the Mark as Answer button if a post solves your problem!