Home » RDBMS Server » Performance Tuning » Question on Object Statistics and Query Execution (RDBMS, 9.2.0.6, Solaris 2.8)
Question on Object Statistics and Query Execution [message #325305] Thu, 05 June 2008 12:08 Go to next message
bnienhau
Messages: 4
Registered: June 2008
Junior Member
What effect does changing the statistics (updating, generating, removing, etc.) of tables/indexes have on an already executed query that is using the aforementioned tables/indexes whose statistics have "changed"? In short, once the execution of the query has started, does changing the statistics of said query's objects (tables/indexes) while it's still in execution mode have any effect on the execution time, or only on any subsequent executions of the query?

Report message to a moderator

Re: Question on Object Statistics and Query Execution [message #325307 is a reply to message #325305] Thu, 05 June 2008 12:13 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>does changing the statistics of said query's objects (tables/indexes) while it's still in execution mode have any effect on the execution time,
No
>or only on any subsequent executions of the query?
yes

http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

Report message to a moderator

Re: Question on Object Statistics and Query Execution [message #325310 is a reply to message #325307] Thu, 05 June 2008 12:24 Go to previous message
bnienhau
Messages: 4
Registered: June 2008
Junior Member
Thanks.

Report message to a moderator

Previous Topic: Index Monitoring
Next Topic: query takes so much time to update
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 22 21:45:26 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.