Re: Improving performance on global temp tables

From: Robert Klemme <bob.news_at_gmx.net>
Date: Wed, 8 Mar 2006 17:46:48 +0100
Message-ID: <478g3rFeggh5U1@individual.net>

beckmatg_at_email.uophx.edu wrote:
> We are using transactional global temp tables to handle complex
> queries in stored procedures. Is there a way to improve performance
> with the temp tables?

Indexing, moving to differnt tablespace or disk... Depends on what exactly your performance problems are.

robert Received on Wed Mar 08 2006 - 10:46:48 CST

This message: [ Message body ]
Next message: Sameer: "Re: Data Entry in Oracle"
Previous message: Robert Klemme: "Re: oracle 10g bug or sth wrong of my code?"
In reply to: beckmatg_at_email.uophx.edu: "Improving performance on global temp tables"
Next in thread: bdbafh_at_gmail.com: "Re: Improving performance on global temp tables"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US