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.
    thanx
    sachin
  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