db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mustafa sener <msen...@yahoo.com>
Subject Re: Query performance of joining table and a view
Date Tue, 01 Aug 2006 13:20:21 GMT
>>One thing I'd try is creating the statement without using the view. 

>>That is, merge the view creation statement in with your select, and see if
>>that helps. I had a similar problem using Oracle one time, where the
>> distinct-ness of the view killed my performance. It turned out that the
>>view had to be materialized for every row in the correllated subquery,
>>which as you can expect, really ate up the time.

Hi I tried same query on oracle. I created sam e tables and data. 
However, oracle performed query very quickly. It finished its job in 12 sec. 
As i mentioned in my previous mail. I solved the problem by changing my query.
I removed inner join. It completed in 3 sec.



Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2ยข/min
or less.
View raw message