| Subject | Descending PK/FK index |
|---|---|
| Author | Ivan Prenosil |
| Post date | 2007-09-18T14:42:38Z |
Since FB1.5 it is possible to specify that automatically created PK/FK indexes
can be descending. The release notes also state
"Caution - Make sure that foreign key and primary key indexes use the same
sort order (DESC | ASC )."
Is this restriction still valid for FB2 ?
( I just created test tables and inserted some data just fine. Shoud I avoid
mixing Desc/Asc constraints anyway ? )
Ivan
can be descending. The release notes also state
"Caution - Make sure that foreign key and primary key indexes use the same
sort order (DESC | ASC )."
Is this restriction still valid for FB2 ?
( I just created test tables and inserted some data just fine. Shoud I avoid
mixing Desc/Asc constraints anyway ? )
Ivan