[MonetDB-users] Table column order and type

Hi, From what I understand indexes are indicative[1], sortedness is determined at runtime[2] and the storage model should not effect the general schema design[3]. Has anyone had any experience with large time series where the column order and types have effected performance? For example having data with less variance and "uniqueness" earlier in a table and splitting up timestamps and storing their date and daytime components separately. Thanks, Pete [1]http://www.monetdb.org/Documentation/Manuals/SQLreference/Indices [2]http://old.nabble.com/column-sortedness-to33053179.html#a33053179 [3]http://old.nabble.com/General-Questions-on-Columnar-DB-Design-and-Querying-t...