Updatable column - index column consideration
From: Antony Raj <ca_raj_at_yahoo.com>
Date: Fri, 10 Feb 2012 13:09:20 -0800 (PST)
Message-ID: <1328908160.59877.YahooMailNeo_at_web36806.mail.mud.yahoo.com>
Hi,
I have a huge table say 50 million rows.It has a status_flag column and it's values are 'H' and 'C'. Everyday,a job inserts ~85000 rows into this table with a status_flag='P' and at the end of proceesing the batch job,the status_flag is gettin updated from 'P' to 'C' and the previous day's rows(identified by jobid) are updated from 'C' to 'H'.
Since this column status_flag is getting updated and volatile in nature,is it recommended not to index this column??
There are few other SELECT statements using status_flag as one their predicates.
Thanks
Date: Fri, 10 Feb 2012 13:09:20 -0800 (PST)
Message-ID: <1328908160.59877.YahooMailNeo_at_web36806.mail.mud.yahoo.com>
Hi,
I have a huge table say 50 million rows.It has a status_flag column and it's values are 'H' and 'C'. Everyday,a job inserts ~85000 rows into this table with a status_flag='P' and at the end of proceesing the batch job,the status_flag is gettin updated from 'P' to 'C' and the previous day's rows(identified by jobid) are updated from 'C' to 'H'.
Since this column status_flag is getting updated and volatile in nature,is it recommended not to index this column??
There are few other SELECT statements using status_flag as one their predicates.
Thanks
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 10 2012 - 15:09:20 CST