Re: Query Performance

Hi,
Try Increasing the shared_pool_size.
..Kiran

"Deborah Carter" <dcarter_at_cnfei.com> wrote in message news:j4xZ4.753$RT3.1291009_at_firenze.visi.net...
> I am working on this project writing a procedure to select information out
> of some rather large tables and insert them into another table. The
> procedure runs for about 6-8 minutes. How can I improve this performance?
> I believe my select statements are optimized. I just don't know what else
> to check or do to speed up the performance. The query takes so long. I
 was
> thinking about reorganizing the largest tables as index-organized tables.
> How will this effect performance? What are the drawbacks to
 index-organized
> tables? Any suggestions are appreciated.
>
> Deborah Carter
>
>
Received on Fri Jun 02 2000 - 00:00:00 CDT