Index Efficiency
From: oracledba <oracledba71_at_gmail.com>
Date: Fri, 19 Apr 2013 22:20:13 -0400
Message-ID: <CA+eRr5G0FqOpwBbrJDOcZzuNwZa+3q0uPXyG_3SEmSoUG0=s7Q_at_mail.gmail.com>
I have used Jonathan's index efficiency script to plot the graph.The graph is attached with this mail.
This index is a single column index ( it's like a status column which has only 4 values say 1 - completed,2- declined,3-suspended,4-unknown).This table is populated every day and this column's values other than 1 and 2 are updated with a new status based on daily's data. By looking at the graph,what do you infer? How effiecient the index is?
Date: Fri, 19 Apr 2013 22:20:13 -0400
Message-ID: <CA+eRr5G0FqOpwBbrJDOcZzuNwZa+3q0uPXyG_3SEmSoUG0=s7Q_at_mail.gmail.com>
I have used Jonathan's index efficiency script to plot the graph.The graph is attached with this mail.
This index is a single column index ( it's like a status column which has only 4 values say 1 - completed,2- declined,3-suspended,4-unknown).This table is populated every day and this column's values other than 1 and 2 are updated with a new status based on daily's data. By looking at the graph,what do you infer? How effiecient the index is?
Thanks
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Apr 20 2013 - 04:20:13 CEST