Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Query Performance
Deborah,
If you would submit the syntax of the SQL SELECT you're performing, the size of the table, and the number of rows reported, we would be happy to determine if the OMNIDEX database search engine would improve your query performance.
Cheryl Grandy
cgrandy_at_disc.com
303 444-4000
www.disc.com/eval.html
In article <j4xZ4.753$RT3.1291009_at_firenze.visi.net>,
"Deborah Carter" <dcarter_at_cnfei.com> wrote:
> 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
>
>
-- Cheryl Grandy DISC Get OMNIDEX for the fastest applications ever Sent via Deja.com http://www.deja.com/ Before you buy.Received on Mon Jun 05 2000 - 00:00:00 CDT
![]() |
![]() |