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
Time has come to start reading about filegroup and/or archiving/purging. then apply whatever fit best in your environment.
----------
Ashish