Query Performance

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 Thu Jun 01 2000 - 00:00:00 CDT