Re: partitioning on varchar column?
You can either do partitioning by KEY, which works with all column types and is similar to HASH partitioning (partitioning pruning requires equal comparison to work with both KEY and HASH). Or try the new partitioning type 'column_list' at
https://code.launchpad.net/~mikael-ronstrom/mysql-server/mysql-5.1-wl3352
So if your queries looks like "SELECT x FROM t WHERE varchar_col = 'string'", then KEY PARTITIONING would be the type to use.
Subject
Views
Written By
Posted
7147
December 24, 2008 01:27AM
Re: partitioning on varchar column?
4875
January 01, 2009 06:16AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.