Maintaining the database

If a database is keeping larger and larger in size, and having more than 1M
records.
How to improve the search speed in that database, even I did index the key..
ThanksIndexing is the key (no pun intended) to search performance. However, you
also need to make sure query expressions are sargable and the query is well
written.
Perhaps someone can offer specific suggestions if you post the CREATE TABLE,
indexes, query and sample data.
--
Hope this helps.
Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/
"Michael Lam" <[nospam]lamsoft@.lamsoft.net> wrote in message
news:uLjaiGfeIHA.4312@.TK2MSFTNGP03.phx.gbl...
> If a database is keeping larger and larger in size, and having more than
> 1M
> records.
> How to improve the search speed in that database, even I did index the
> key..
> Thanks
>