Re: Версионность и протоколирование записей

Wed, 18 Oct 2006 09:24:28 -0700 

On Wed, 18 Oct 2006 19:22:24 +0400, Dmitri Kuzmenko <[EMAIL PROTECTED]> wrote:
> select value, max(date)
> from currency
> where currency_code = :param
> group by value

create descending index cur_idx on currency (date, currency_code);

for select value, date
   from currency
   where date <= :param1 and currency_code = :param2
   order by date desc
   into out_value
do begin
   suspend;
   exit;
end

Что тут медленного будет?

-- 
Сергей Смирнов.

Ответить