Indexes in SQL tables

[Becky]

Hi, I'm looking for ways to optimize the data processing in my database as
the number of records is growing bigger and bigger now. I'm currently use
unclustered index in my tables.
How can i optimize the data processing further ?

Can anybody give some advices?

Looking forward to hear from you. Thank you.

Becky

[Neil Pike]

Becky - this is an impossible question to answer without knowing a lot more
about the tables, the data, the indices, the access-patterns etc.

> Hi, I'm looking for ways to optimize the data processing in my database as
> the number of records is growing bigger and bigger now. I'm currently use
> unclustered index in my tables.
> How can i optimize the data processing further ?
>
> Can anybody give some advices?
>
> Looking forward to hear from you. Thank you.
>
> Becky
>

Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (faqrtf.zip - L7
- SQL Public)
or http://www.ntfaq.com/Section.cfm?sectionID=34
or www.sqlserverfaq.com
or www.mssqlserver.com/faq