select * from tablea inner join (select * from TableB inner join TableC) InnerSQL ....>We have the following query:
>SELECT Custname, wono, pno.part_no, pno.revision, to_dept_id, CountToDate, shipdate; > FROM crspartno pno; > INNER JOIN inventor ON pno.uniq_key = inventor.int_uniq; > INNER JOIN crsCustsSel cust ON inventor.custno = cust.custno; > ORDER BY custname, pno.part_no, to_dept_id; > INTO CURSOR crsmovedfinal READWRITEwhich runs very slowly. The query plan shows
>SELECT Custno, wono, pno.part_no, pno.revision, to_dept_id, CountToDate, shipdate; > FROM crspartno pno; > INNER JOIN inventor ON pno.uniq_key = inventor.int_uniq; > INTO CURSOR crsmovedfinal READWRITE>
>SELECT Custname, wono, part_no, revision, to_dept_id, CountToDate, shipdate; > FROM crsmovedfinal mv; > INNER JOIN crsCustsSel cust ON mv.custno = cust.custno; > ORDER BY custname, part_no, to_dept_id; > INTO CURSOR crsmovedfinal READWRITE>
>INNER JOIN myTable ON condition USING INDEX TAGSbut is there some way to structure the query so that Rushmore will do a better job selecting which tags can be used?