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
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.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
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