Thanks for your reply.

One more thing

I am using fulltext search for the searching the data from that table but it is taking around 2 mins for some of the search...

I have normalized the tables and i have around 10 tables which have data. for performance improvement I created one table which have all the required data from all these...

I am returning around 15 fields , some are using in the order by , one in group by , 6 in fulltext search and 10in where clause