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/