SQL Server Performance

Query Performance

Discussion in 'T-SQL Performance Tuning for Developers' started by shafiq, Feb 5, 2003.

  1. shafiq New Member

    I have a table with over 70 million records. Columns are profileid(Table Index), email, lastname, first name, address1, address2, city, state, zip, country, phone1, phone2, gender, maritalstatus and spouse. When i run a simple query on that, it take 10 to 14 mins. How can i reduce query time?
    (a) With the help of re-organization of indexing
    (b) Partitioned views
    or any thing else

    Thanks in Advance
    shafiq, Feb 5, 2003
    #2

  2. satya Moderator

    Well if you look in to the home page of this site and refer to the tips listed by section wise, especially for Indexes, partitioned views and queries.

    HTH

    Satya SKJ
    satya, Feb 6, 2003
    #2

  3. bradmcgehee New Member

    View the execution plan of your query. It will tell you where the table or cluster scan is taking place. In most cases, adding an index to the column being scanned will help. But it is not always as simple as this, as you will need to consider all of the potential queries running against your table. You may also want to try the Index Wizard, as it is good for identifying needed indexes.

    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com
    bradmcgehee, Feb 6, 2003
    #2

Share This Page