>I am attempting to look thru my app for ways to improve speed. I have read all the VFP help stuff on optimization and rushmore.
>
>My tables: Inmates,Cells,Classifications,Bill_Codes.
>Each table has a primary key which is a guid().
>Each table has 1 index on this primary key.
>That is the only index on each of these tables.
>
>Here is my simple test:
>
>These are the exact commands I am issuing from the command window. According to my understanding of the VFP help, this should tell me how well the query is being optimized.
>
try:

SYS(3054,11,'cmemvar')

>OPEN DATABASE C:\ITF\DATA\INMATETRUSTFUND.DBC
>
>SELECT INMATES.CID,;
> INMATES.CINMATE_NUMBER,;
> CELLS.CCELL_NAME,;
> PADR(ALLTRIM(INMATES.CLAST)+", "+" "+ALLTRIM(INMATES.CFIRST)+" "+ALLTRIM(INMATES.CMIDDLE),50) AS CNAME,;
> Classifications.cclassificationdesc,;
> Bill_Codes.cbillcd;
> FROM INMATETRUSTFUND!INMATES;
> LEFT JOIN INMATETRUSTFUND!CELLS;
> ON INMATES.CCELLS_ID = CELLS.CID;
> LEFT JOIN INMATETRUSTFUND!CLASSIFICATIONS;
> ON INMATES.CCLASSIFICATIONS_ID = CLASSIFICATIONS.CID;
> LEFT JOIN INMATETRUSTFUND!BILL_CODES;
> ON INMATES.CBILL_CODES_ID = BILL_CODES.CID;
> WHERE INMATES.CSTATUS='OPEN';
> ORDER BY INMATES.CLAST, INMATES.CFIRST;
> INTO CURSOR lcresult
>
>?cmemvar returns the following information:
>
>Rushmore optimization level for table inmates: none
>Rushmore optimization level for table cells: none
>Rushmore optimization level for table classifications: none
>Rushmore optimization level for table bill_codes: none
>
>Should't this simple view be filly optimized? What am I either not understanding or missing?
>
>Thanks,
>John