| Subject | Descending FK index |
|---|---|
| Author | Ivan Prenosil |
| Post date | 2008-03-19T16:12:32Z |
What can be the consequences of combining Ascending PK index
with Descending FK index (or vice versa) ?
FB1.5 release notes say
"Caution - Make sure that foreign key and primary key indexes use the same sort order (DESC | ASC )."
but FB (2.x) will create it without complains, and it seems to work as expected too.
Ivan
with Descending FK index (or vice versa) ?
FB1.5 release notes say
"Caution - Make sure that foreign key and primary key indexes use the same sort order (DESC | ASC )."
but FB (2.x) will create it without complains, and it seems to work as expected too.
Ivan