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?
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: 25036
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
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.
Previous Topic: Index Monitoring
Next Topic: query takes so much time to update
Goto Forum:
  


Current Time: Sat Dec 03 22:38:16 CST 2016

Total time taken to generate the page: 0.10217 seconds