DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Poerformance Issue

  1. 12-14-2005, 06:44 AM #1
    sarovb
    sarovb is offline Junior Member
    Join Date
    Sep 2003
    Posts
    49

    Poerformance Issue

    hi
    Our oracle reports application uses 150 temporary tables. Temp tables impact database performance? Am i right?

    Kindly suggest or give some alternative solution for global temporary tables.
    Reply With Quote Reply With Quote
  2. 12-14-2005, 07:36 AM #2
    tamilselvan
    tamilselvan is offline Senior Advisor
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Are they "global temporary tables"?

    Tamil
    Reply With Quote Reply With Quote
  3. 12-14-2005, 05:50 PM #3
    gamyers
    gamyers is offline Member
    Join Date
    Feb 2005
    Posts
    158
    "Temp tables impact database performance?"
    Yes. By dropping all your temporary tables before you query them, the query ends very quickly. The only drawback is that is ends with an error saying the table does not exist.

    Seriously, temporary table do a job. You use them when they are appropriate, and don't use them when they are not appropriate. What performance problems are you having, and why do you think temporary tables are causing them ?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width