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

Reply via email to