Well, I guess if I expect the table to grow over time? But I guess you
are saying that for a table with 44 records, any index is more trouble
than it is worth.

-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Tuesday, November 04, 2003 11:56 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Selectivity Question


At 11:29 PM 4/11/2003 -0800, you wrote:

>This is really great information. Are there any rules on when an index
>is more trouble to maintain than it is worth? Say if I have an index
>with a selectivity of 0.333 over 44 records. Also, it seems like one
>could easily be misled, for example, you might have a completely unique
>index but only currently have two records, thus resulting in a
>selectivity of 0.5.

Well, why would you want to have an index on a table with 2 records or
44?

The value of SET STATISTICS and getstat is for troubleshooting
performance
on tables you're actually using. The selectivity + the "geometry" stuff
is
great for that.

Helen



Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.