 |
 |
Archives of the TeradataForum
Message Posted: Thu, 17 Apr 2003 @ 20:49:06 GMT
| Subj: | | Create testing plan for big tables join |
| |
| From: | | Tan, Yvonne |
Greetings!
We are building a view that has 11 history tables join. Each history table contains 19 million records. Our test environment only has
700,000 records for us to test the view performance. Is there a way I can predict the production performance (i.e., DBMS time, Fetch time,
and spool space used) by running explain based on 700,000 test records? Please advise.
Thanks,
Yvonne
| |
