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

   sqlserverfaq, Oct 4, 2005

   #2
2. Madhivanan Moderator

   Post the table structure and the query you used
   
   Madhivanan
   
   Failing to plan is Planning to fail

   Madhivanan, Oct 4, 2005

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in