SQL Server Performance

Output Slow

Discussion in 'General DBA Questions' started by sqlserverfaq, Oct 4, 2005.

  1. sqlserverfaq New Member


    I have a table in which 5 lakhs records and when i fire a query on this table i get the output 3 minutes and on that table full text search is there and i have put index on the table.

    As the output is very slow and i want the output to be in 1 minutes.

    Please suggest the solution for this.

    Regards
    Pavan A
  2. Madhivanan Moderator

    Post the table structure and the query you used

    Madhivanan

    Failing to plan is Planning to fail

Share This Page