Re: Design question regarding event log table processing

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Fri, 25 Jan 2013 02:19:10 +0400
Message-ID: <CAOVevU5CtcZV7xh3+PtOMY4+8sremjRPLCVnS79f5jcpxMCALg_at_mail.gmail.com>

David, i mean index on "NotProcessed" column only - it will be smaller, because only not processed rows will be in index. So all operations would be through IFS/IFFS.

--

Best regards,
Sayan Malakshinov
Senior performance tuning engineer
PSBank
http://orasql.org
--

http://www.freelists.org/webpage/oracle-l Received on Thu Jan 24 2013 - 23:19:10 CET