On Fri, Aug 22, 2008 at 03:42:40AM +0200, Stefan de Konink wrote:

Hi,

If a user places an index on a varchar column will the actual character storage move to an intermediate (or final) column with only unique instances of each string. Or will the storage in the original table definition still contain all materialized string, instead of pointers to the index?

There are 2 indices in monetdb. The prime purpose are to speed up primary and foreign key checks. Both only store numbers (hash values and oid's for the primary-foreing key relation). So we cannot reduce the varchar storage in this case.

However the primary storage of varchar's does allready do this duplicate elimination and only stores pointers too strings.

Niels

Stefan

---

This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers