December 17, 2012 at 3:18 am
Hi
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
pradeep
December 17, 2012 at 3:23 am
Please follow the link in my signature on posting performance problems.
But have you checked the execution plan, index fragmentation, use of indexes, missing indexes etc etc etc?
December 17, 2012 at 6:36 am
mpradeep23 (12/17/2012)
HiWe 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
pradeep
As others have said on this thread and the other, you haven't provided enough information to really provide you with any help. Please read the first two articles I have referenced below in my signature block regarding asking for help and asking for help on performance tuning. These articles will guide on what you need to provide to get the best possible answers.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply