Indexes in SQL tables


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Indexes in SQL tables

  1. #1
    Becky Guest

    Indexes in SQL tables


    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

  2. #2
    Neil Pike Guest

    Re: Indexes in SQL tables

    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



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center