Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Session TEMPORARY TABLES TO SPEED UP PERFORMANCE

13885Sep 1 2003 — edited Sep 3 2003

I AM PLANNING TO USE TEMPORARY TABLES TO SPEED UP PERFORMANCE OF COMPLEX QUERIES .THE DB SERVER IS ORACLE 8i REL 3.0 (8.1.7) on windows 2000 with remote connectivity

I HAVE THE FOLLOWING QUERIES ON TEMPORARY TABLES .PL RESPOND WITH U'R SOLUTIONS/SUGGESTIONS AND IMPLEMENTATION METHODS .THANX FOR THE ASSISTANCE

1)ARE THERE REAL ADVANTAGES OF TEMPORARY TABLES OVER VIEWS .

2)IS THERE ANY WAY TO CHECK HOW THE TEMPORARY TABLES ARE BEING PUT TO TASK EFFECTIVELY .IS THERE ANY DATA DICTIONARY VIEWS WHICH WILL GIVE THE STATISTICS OF TEMPORARY TABLES USAGE BY QUERIES.

3)WILL MY EXPLAIN PLAN/PLAN_TABLE WORK WELL WITH TEMPORARY TABLES AND ARE THERE ANY OTHER WAY TO CHECK THE EFFECTIVENESS OF TEMPORARY TABLES.

4)ARE THERE ANY TUNING ISSUES WITH TEMPORARY TABLES.

PRESENTLY I HAVE BEEN USING COMPLEX VIEWS ON WHICH MY QUERIES ARE DIRECTED .

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 1 2003

Added on Sep 1 2003

#general-database-discussions

4 comments

470 views