Remove the FORCE keyword. It tells Rushmore not to kick in.

Also, you'd be well advised not to use a and b as local aliases. They can

cause problems. Avoid the letters a-j and m because of their historical use

as work area designators.

Tamar

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

From: profox@leafe.com [mailto:profox@leafe.com]On Behalf Of Inna :)

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

__________________________________________________

Do You Yahoo!?

Make international calls for as low as $.04/minute with Yahoo! Messenger

http://phonecard.yahoo.com/