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.