Hi all, I have records w/ a timestamp attribute which is not unique and cannot be used as a primary key. These records will be inserted according to timestamp value. From this important fact, I've gathered I need a clustered index since my SELECT statements use a time-range in the WHERE clause.
Does sqlite support clustered indexing or something that would take advantage of nature of my records and the nature of how they're being inserted? Please let me know. Thanks, Julian _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users