Subject | Foreign keys like index |
---|---|
Author | Sasa Mihajlovic |
Post date | 2007-06-16T17:14:07Z |
Hi,
I have a little newbie question for Firebird masters.
If I have 2 tables (for example) orders and customers where orders
are "slave" table for customers with foreign key on it.
if I write statement like this:
select c.name, c.city, o.orderno, o.orderdate
from orders o
join cutomers c on c.id = o.cutd_id
order by c.name
does firebird use foreign key like index
I have a little newbie question for Firebird masters.
If I have 2 tables (for example) orders and customers where orders
are "slave" table for customers with foreign key on it.
if I write statement like this:
select c.name, c.city, o.orderno, o.orderdate
from orders o
join cutomers c on c.id = o.cutd_id
order by c.name
does firebird use foreign key like index