Re: B-tree or cluster b-tree?

Date: 09-02-10
From: Peter Jakobsson <lists_at_netkelvin.com>

On 9 Feb 2010, at 18:12, David Rose wrote:

> Number of distinct values in indexed Field 1: 700
> Maximum number of same values in Field 1: 25,000
> Minimum number of same values in Field 1: 1

Off the top of my head, I'd just leave that as a b-tree unless you're
regularly searching on the value that returns 25000 results.

(I don't know why I'm speaking so authoritatively my total experience
of experimenting with different index types = o, so this is pure
speculative theory !)

My original post about this was based around the idea that you could
get very far with very little thought by only addressing the extreme
cases initially. For example, in a big database (3-4 million
transaction records per table in 10 tables) where product type and
product group are indexed and where there are less than 50 types and
groups, this is a no-brainer situation for a cluster I thought.

Peter

**********************************************************************
The New 4D Partner Program - All the tools you need to be a successful 4D Developer.
Sign up Now: http://www.4d.com/community/partner/registration.html


4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4D_Tech-Unsubscribe_at_lists.4D.com
**********************************************************************