[MonetDB-users] MonetDB Indexes and Data Types
Hi All - I'm new to MonetDB and just getting my feet wet. Quick question for the experts. Does the data type of the column impact the performance of the indexes created on the fly by MonetDB? In other words, should I expect WHERE clauses on INT columns to perform faster than VARCHAR like I would in a tradtional row store? Many Thanks, Ross
Ross Bates wrote:
Hi All - I'm new to MonetDB and just getting my feet wet.
Quick question for the experts. Does the data type of the column impact the performance of the indexes created on the fly by MonetDB? In other words, should I expect WHERE clauses on INT columns to perform faster than VARCHAR like I would in a tradtional row store?
sure.
Many Thanks, Ross
------------------------------------------------------------------------- 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-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
Martin Kersten -
Ross Bates