Subject | does FB support clustered indices? |
---|---|
Author | judlian23 |
Post date | 2008-10-24T22:54:03Z |
Hi everyone,
I saw on a post from 2006 that FB does not support clustered indices.
I am currently using Firebird-2.1.1.17910-0_Win32_embed. Does this
version support clustered indices? I did not see it in the SQL:2003
standard, but then again, that nuances of that version of SQL is a
little foreign to me.
What I mean by clustered is that I need records placed in my DB in
order. I want them sorted by time, and these records will be inserted
by time, so hopefully inserts would be fast with a clustered index
because the db just needs to append the record.
Please let me know.
Thanks,
Julian
I saw on a post from 2006 that FB does not support clustered indices.
I am currently using Firebird-2.1.1.17910-0_Win32_embed. Does this
version support clustered indices? I did not see it in the SQL:2003
standard, but then again, that nuances of that version of SQL is a
little foreign to me.
What I mean by clustered is that I need records placed in my DB in
order. I want them sorted by time, and these records will be inserted
by time, so hopefully inserts would be fast with a clustered index
because the db just needs to append the record.
Please let me know.
Thanks,
Julian