Update Statistics
From: Rob Panosh <rob_panosh_at_asdsoftware.com>
Date: Wed, 16 Oct 2002 15:54:02 -0500
Message-ID: <3dade05c$1_at_news.splitrock.net>
Date: Wed, 16 Oct 2002 15:54:02 -0500
Message-ID: <3dade05c$1_at_news.splitrock.net>
Anybody,
I have an applications that runs against an Oracle 8i database ( 8.1.7 ) and all of a sudden I noticed that my select statements came to a crawl. Once I ran compute statistics my SQL Select Statement performance went back to normal. Can anybody give me a explanation about statistics? Is this something I have to run every so often.
Thanks,
Rob Panosh
Received on Wed Oct 16 2002 - 22:54:02 CEST