Re: Design question regarding event log table processing
From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Thu, 24 Jan 2013 14:30:42 -0800 (PST)
Message-ID: <1359066642.41666.YahooMailNeo_at_web121601.mail.ne1.yahoo.com>
I understood what you suggested -- my example was nothing more than that, but it did rely on more than simply the 'indicator' column to process data. Basically it was to show the plans were fairly efficient even as the source table record count grew.
From: Sayan Malakshinov <xt.and.r_at_gmail.com> To: David Fitzjarrell <oratune_at_yahoo.com> Cc: "bl_at_brunol.com" <bl_at_brunol.com>; "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Thursday, January 24, 2013 3:19 PM Subject: Re: Design question regarding event log table processing
Date: Thu, 24 Jan 2013 14:30:42 -0800 (PST)
Message-ID: <1359066642.41666.YahooMailNeo_at_web121601.mail.ne1.yahoo.com>
I understood what you suggested -- my example was nothing more than that, but it did rely on more than simply the 'indicator' column to process data. Basically it was to show the plans were fairly efficient even as the source table record count grew.
David Fitzjarrell
From: Sayan Malakshinov <xt.and.r_at_gmail.com> To: David Fitzjarrell <oratune_at_yahoo.com> Cc: "bl_at_brunol.com" <bl_at_brunol.com>; "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Thursday, January 24, 2013 3:19 PM Subject: Re: Design question regarding event log table processing
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:30:42 CET