| Subject | Re: [firebird-support] Why index is not used in this query? |
|---|---|
| Author | Ann Harrison |
| Post date | 2015-05-15T13:16:56Z |
On May 15, 2015, at 9:02 AM, brucedickinson@... [firebird-support] <firebird-support@yahoogroups.com> wrote:
SELECT * FROM
SELECT * FROM
TABLE_2 T2
INNER JOIN
TABLE_1 T1
ON
T2.TABLE_1_ID = T1.ID
After executing this query I am getting such plan:PLAN JOIN (T1 NATURAL, T2 INDEX (FK_TABLE_2))