Inna,

You do have an index on fb_flag, don't you? Rushmore can only work if you

have an index built on the expression listed in your WHERE clause.

Also, while Rushmore doesn't do JOINs, you can further optimize your query

by ensuring you have indexes on your account column in both tables.

OH! Why do you have the FORCE clause in this query? That changes things...

-Chuck Urwiler, MCT, MCSD, MCDBA

Sr. Instructor/Consultant

http://www.microendeavors.com

http://www.hentzenwerke.com/catalogavailability/csvfp.htm

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

From: Inna :) [mailto:inulia25@yahoo.com]

Sent: Tuesday, July 31, 2001 11:48 AM

To: Multiple recipients of ProFox

Subject: Rushmore Question

Hello,

I can't seem to get Rushmore to work - all my queries

return 'Rushmore Optimization: none'.

The following is one of the queries I'm trying to

optimize:

SELECT b.a_fund, a.a_fncgrp, a.amount;

FROM force acctdet a left join chart_ac b;

on a.account = b.account;

WHERE a.fb_flag # 'Y';

INTO CURSOR tmp_act1

chart_ac table has approx 50,268 records consisting of

all unique accounts

acctdet table has approx 233,021 records consisting of

multiple records per account.

Thanks in advance,

Inna