SQL Server Performance

performance slow

Discussion in 'SQL Server 2008 Performance Tuning for DBAs' started by ksachinsoni, Sep 10, 2009.

  1. ksachinsoni New Member

    hello friends i have a table which has 2 lacs records only and 40 colms (one have images) bt wen i run select query, it takes around 15 mins to come out 2 lacs record. wat is the problem want to knw. it has clusterd index, and fulltext index also, want to improve the performnce.
  2. Adriaan New Member

    Well, you mention having a column with images ...
    Say your table has columns col1, col2 and colimage. Compare the response time for these two queries:
    SELECT t.col1, t.col2, t.colimage FROM MyTable t
    SELECT t.col1, t.col2 FROM MyTable t
  3. ksachinsoni New Member

    ya it is returning result in 40 seconds bt it is again too long time,
  4. Adriaan New Member

    So what kind of query tool / client application are you using?
    And does the table have a primary key?
  5. moh_hassan20 New Member

    can you post thhe query and excecution text plan

Share This Page