Hi all!

We have a query and whant to secure maximum speed. How shall I interpret =

the

Sys(3054,11) report?

Is there more to do?

Sys(3054,11) reports:

Rushmore optimzation level for tblcomp1: none

Rushmore optimzation level for tblaccomps: none

Rushmore optimzation level for tblcont1: none

Rushmore optimzation level for tblacconts: none

Joining tblcomp1 and tblaccomps using index tag Acctocomp

Joining intermediate result and tblcont1 using temp index

Joining intermediate result and tblacconts using temp index

The query:

Select tblComp1.Company, tblCont1.aftername, tblCont1.forename,

TblCont1.ct1_ct234, ;

TblComp1.c1to234, tblComp1.Det014,tblComp1.Det015,tblCont1.Det014 as

ContDet014 ;

FROM tblComp1 ;

LEFT JOIN tblAccomps ON tblComp1.C1To234 =3D tblAccomps.AccToComp ;

LEFT JOIN tblCont1 ON tblComp1.C1To234 =3D tblCont1.Ct1_c1_234 ;

LEFT JOIN tblAcconts ON tblCont1.Ct1_ct234 =3D TblAcconts.AccToCont1

The tables have following indexes:

tblComp1.C1To234 Primary

tblAccomps.AccToComp Regular

tblCont1.Ct1_c1_234 Regular

tblCont1.Ct1_ct234 Candidate

TblAcconts.AccToCont1 Regular

Why doesn=B4t Rushmore use my indexes? What am I doing wrong? Any help wo=

uld

be very apppreciated.

Regards Roland