[b]Performance Issue select statement[/b]

[kiabathe]

Hi, New to PL/SQL and trying to write a scripts which calculate the elapsetime from different metric. I need to join two tables table1 and table2. Table1 has 240 rows and most of the metrics are coming from that table. Table2 has about 200000 rows, and only one column is used against this table. This query takes 26 seconds for single records, and every time these two tables are joining for each record. I have tried creating seperate table, and view for join. It has not improved the performance.
Please help me out!

select sum(elapsedtime) from Table1, Table2
where
table1_id = table2_count

Thanks
Aziz

 

[sem]

Do you have indexes on that tables? If not, can you create one on table2_count (a field from Table2, isn't it?). If yes, are they used?

Regards, Dima

http://seminihin.narod.ru

 

[dbtoo2001]

There are so many factors with performance tuning. Your asking for a bindfolded guess.

Start here:

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/sql_1016.htm#30972

If you get prompted for a userid, Sign up, it's free.