FAQ

Execution plan changes after truncate and re-load

Author: asktom.oracle.com
Category: Oracle FAQ
Comments (0)

Hi Tom, Can you explain why the execution plan for a query changes after truncating and reloading tables with exactly the same data ? Here's my example : -- -- Create Tables -- CREATE TABLE CUSTOMER_DIM ( MONTH_KEY ...

Read More...

Sponsored Links

Read Next: Skills for future

Comments

Subscribe via RSS

Subscribe to GeekArticles.com by Email

Enter your email address:

Subscribe in a reader

Oracle FAQ

Synchronize data from remote location
Oracle Fundamentals
How to connect SQLPlus without tnsnames.ora
Best Practices for App Server Keep Alive
bind variables in triggers
how to avoid outer joins
One 900 column table versus ten 90 column tables.
Does select generate undo ?
Performance Question
Help analyze statspack report

Execution plan changes after truncate and re-load

Comments

Post Your Comment:

Subscribe via RSS

Oracle FAQ

Sponsored Links