We have a table which contains allmost 1 lak to 2 lak of records
querring on that table getting delayed give me idea how to make it faster
Thanks in advance
simple answer is "optimize your query"
Did you get any benefit from my suggestion certainly no ...same happened with me too as i too hadnt get any kind of help or clue from you question . friend , there could be multiple reason.
..bad indexes ... bad queries.... unwanted columns in queries.. heavy volumned adta manipulation .. your hardware congiguration... other backgrpund processes ..network.. etctetc
to get faster result see link in my signature
-------Bhuvnesh----------I work only to learn Sql Server...though my company pays me for getting their stuff done;-)