Index Efficiency
- From: oracledba <oracledba71@xxxxxxxxx>
- To: Oracle-L Freelists <Oracle-L@xxxxxxxxxxxxx>
- Date: Fri, 19 Apr 2013 22:20:13 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
