Replies to This Discussion

Permalink Reply by Philip Calvert on October 8, 2013 at 7:37am

Update the statistics for a temp/physical table.  Metta sql makes it database independent command.

Thanks.

• ▶ Reply

Permalink Reply by Demarcus Sivils on October 8, 2013 at 9:33am

Thanks for sharing your knowledge philip.

• ▶ Reply

Permalink Reply by Lori Erazo on October 22, 2013 at 3:20am

Thanks.

• ▶ Reply

Permalink Reply by David Maňhal on October 22, 2013 at 10:28am

It makes sense to compute statistics only on tables and related indexes for which their content has changed since last statistics computation job. In Oracle database you can use some automation - it will compute stats only for changed objects or for those which have no statistics so far.

for example:

execute dbms_stats.gather_schema_stats(ownname=> 'SYSADM', method_opt=>'FOR ALL INDEXED COLUMNS SIZE AUTO', cascade=>TRUE, options=> 'GATHER AUTO');

Be carefull when computing stats on PeopleSoft temporary tables. If you compute stats on these tables when they are empty it will lead to wrong execution plan.when these tables got populated by some batch job. If the job will try to select data from such tables without recomputing statistics on them first, it might hit performance issue.

• ▶ Reply

Permalink Reply by Mackenzie Lutz on October 23, 2013 at 1:20am

Thanks alot david for the information.it really helped.

• ▶ Reply

Permalink Reply by kristen on July 9, 2017 at 12:13pm

it's a pleasure to meet you. I am USA Army personnel, i have an important thing to discus with you.
Please write me on my email (captkristen899@gmail.com)

• ▶ Reply