Optimizing Queries
Results 1 to 4 of 4

Thread: Optimizing Queries

  1. #1
    Join Date
    Mar 2012
    Posts
    1

    Optimizing Queries

    I have a table with a large number of records (around 3m) which are used in a variety of queries. The primary key is made up of two fields for uniqueness.

    Most of thequeries I use on this table use either one or the other of the 2 key fields. Would it improve query performance if I also indexed each field separately ? Or is there another option to speed things up ?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,895
    Adding non-clustered index on second pkey column may help.

  3. #3
    Join Date
    Mar 2012
    Posts
    1

  4. #4
    Join Date
    Nov 2010
    Posts
    2
    Quote Originally Posted by ankitpor1 View Post
    ditto that

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •