Re: create view performance problem

You could cheat, and create a separate table for the max-value information, then write a trigger on the base table that updates the max-value table.

This could, however, have a serious side-effect on the performance, especially if you have a number of concurrent processes updating the base table.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

vagelis Hristidis wrote in message <7ghkpn$fqt$1_at_ulysses.noc.ntua.gr>...
>I have a table with columns :symbol, st_date,value
>and I would like to create a view with columns:
>symbol,st_date_for_max_value,max_value
>where there is one row for each stock symbol.
>How can I do it so that it performs well?
>The problem is that sql won't let me use st_date in select clause when i
>don't also put it in group by clause.If I use a pl/sql function it's slow.
Received on Sun May 02 1999 - 09:00:45 CDT