Roland,

I posted this on Monday. Did you or Christina try it?

Cindy Winegarden

Microsoft Certified Professional, Visual FoxPro

Duke Children's Information Systems

Duke University Medical Center

cindyw@duke.edu

----- Original Message -----

From: "Cindy Winegarden" <cindyw@duke.edu>

Newsgroups: microsoft.public.fox.programmer.exchange

Sent: Monday, August 28, 2000 5:54 PM

Subject: Re: Rushmore - VFP6/SP4

| Christina,

|

| I don's see mention of an index on TblAcconts.AccToCont1.

|

| Also, Rushmore will not report full optimization unless there is a tag =

on

| DELETED(). However, a tag on ANY field where there are only a few valu=

es

| (M/F, Yes/No) may or may not speed things up, depending a lot on your

| particular situation. There was an excellent article in FoxPro Advisor

| about this.

|

| What you didn't say was whether you were satisfied with the speed of yo=

ur

| query!

|

| (Surely you go nuts with table and field names which are so similar!

;-) )

|

|

| --

|

|

| Cindy Winegarden

| Microsoft Certified Professional, Visual FoxPro

|

| Duke Children's Information Systems

| Duke University Medical Center

| cindyw@duke.edu

|

|

|

| "Christina Lofberg" <ch.lofberg@telia.com> wrote in message

| news:p6wq5.4340$HK.198022@newsc.telia.net...

| | Hi all!

| | I have a 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

| |

| | Sys(3054,11) reports no indexes or only temp indexes are used.

| |

| | The tables have following indexes:

| | tblComp1.C1To234 Primary

| | tblAccomps.AccToComp Regular

| | tblCont1.Ct1_c1_234 Regular

| | tblCont1.Ct1_ct234 Candidate

| |

| | Why doesn=B4t Rushmore use my indexes? What am I doing wrong? Any hel=

p

would

| | be very apppreciated.

| |

| | Regards

| | Christina

| |

| |

|

|