Napoma wrote:
I have this problem... i have a table with 33.000.000 of records.. the table is named i_predicate with four columns as follows (oid, name, isubj, iobj)... i want to execute a physical partition on i-predicate respect to the values of name column.. in this way if i query i_predicate monetdb has to use only the respective partition with the respective value of name...
Database does not seem too large, between 1-2 GB. Common strings are detected and hashing will ensure quick access to the elements with the same name.
does it exist a sql statement for creating partitions of i_predicate?
The SQL frontend does not provide a partitioning option. It is a decision the system should make itself, such features are part of the research. See e.g. the cracker papers, whose code is included in the distribution.
does it exist a script for this partition on MonetDB?
and if i create the partition... i have to define function to query correctly the partitions?
Thanks