| Subject | RE: [ib-support] 3 table join with SQL statements runs slow |
|---|---|
| Author | Leyne, Sean |
| Post date | 2002-06-12T03:28:31Z |
Randy,
indexes for the ALLCANCEL table? How common are the values in these
indexes?
Also, I note that the join to AllSALES (A10) is not by the primary key,
is there a reason for that? How common are the values in the A10.CERT
column?
Sean
> Here is the plan.What are the columns in the Primary Key and ALLCANCEL_PROCESS_DATE
>
> PLAN JOIN (A10 INDEX (RDB$FOREIGN62),D2 INDEX (RDB$PRIMARY21),A9
> INDEX (RDB$PRIMARY7,ALLCANCEL_PROCESS_DATE))
indexes for the ALLCANCEL table? How common are the values in these
indexes?
Also, I note that the join to AllSALES (A10) is not by the primary key,
is there a reason for that? How common are the values in the A10.CERT
column?
Sean