Results 1 to 2 of 2

Thread: Query Optimize.

  1. #1
    Join Date
    Nov 2003
    NJ USA

    Unanswered: Query Optimize.

    Hi all,

    Table 'A' is having 105 fields & 233000 records.
    One Clusterd Primary Key & 10 nonclusterd key.

    If I joined with table 'A' or 'Select * from 'A' , Query takes more time so please let me know best way to structure query or table, Indexes etc.

    Reply to me asap positivaly ....

    M. G.
    M. Jain

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Without having the DDL (the CREATE TABLE and CREATE INDEX statements in particular), and the query(s) that are running slow, I'm pretty severly handicapped in giving you much advice.

    The only real insight that I can give without more informations is to be sure that your statistics are current using the UPDATE STATISTICS statement.


Posting Permissions

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