Home » SQL & PL/SQL » SQL & PL/SQL » Compute Statistics & SQL Performance
Compute Statistics & SQL Performance [message #19022] Tue, 26 February 2002 05:35 Go to next message
Maui
Messages: 2
Registered: February 2002
Junior Member
Hi all,
i've a little question.
If I analyze a schema with dbms_utility.analyze_schema('<schema_name>','ESTIMATE/COMPUTE' ecc. ecc., my queryes against the schema's tables, have poor performance.
If I delete the statistics, my queryes become very fast.
What's the matter ?
Thanks in advance.

Report message to a moderator

Re: Compute Statistics & SQL Performance [message #19023 is a reply to message #19022] Tue, 26 February 2002 06:31 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
can u tell me , what is your optimizer_mode ?

Report message to a moderator

Previous Topic: Re: How do i populate a LOV with values from a cursor?
Next Topic: trigger
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 20:05:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.