Re: Index Efficiency

From: oracledba <oracledba71_at_gmail.com>
Date: Sat, 20 Apr 2013 09:37:39 -0400
Message-ID: <CA+eRr5GVJaBfxtou8Ax2o-fcpCSBh7p9dL3-9sOJJ=v6eBbn=w_at_mail.gmail.com>

Yes. The values 1 is more popular than othe r values. -- ----------
 1 22615636
 2 2362463

 3      36228
 4     391915

[image: Inline image 1]

On Sat, Apr 20, 2013 at 12:19 AM, Mark W. Farnham <mwf_at_rsiz.com> wrote:

> I don't see the graph, but I do have a suggestion.
>
> Now I don't know whether "completed" or "declined" is a more popular value,
> but let's say most things end up "completed."
>
> If your applications can manage interpreting NULL as completed, then you
> can
> probably permanently and dramatically shrink the size of your index by
> using
> the value NULL instead of 1 for completed.
>
> This seems to match your brief description of your use case below. Your
> mileage may vary.
>
> mwf
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of oracledba
> Sent: Friday, April 19, 2013 10:20 PM
> To: Oracle-L Freelists
> Subject: Index Efficiency
>
> 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-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Apr 20 2013 - 15:37:39 CEST