Subject | RE: [firebird-support] Large row count in tables |
---|---|
Author | Alan McDonald |
Post date | 2009-08-03T22:29:32Z |
> I have an asc and desc index on ID/Time for (time) ranged queries. Cantthis makes no sense at all.
> have a primary index since there is no unique data.
1. using a primary key is for the very reason that otherwise there is no
unique data.
2. if you have 2 rows which are identical, then you are in trouble since an
SQL database does not like being unable to determine one row from another.
3. creation of a primary key is under your control - make one.
Alan