Need help with Rushmore optimization SYS(3054)

[adamocean]

How come my queries are not optimized?

Lets say I have 2 tables, each with a field containing an id (sys(2015)), If I run a select statement :

Sele * from table1,table2 where table1.id = table2.id

and both id fields in these tables are optimized, it says rushmore optimization is none?

Hope that was clear!

 

[ramani]

Hi

Try...
Sele a.*, b.* from table1 a, table2 b ;
where a.id = b.id .AND. a.id > "" .AND. b.id > ""


Please note.. if your intention is to bring all the records of 1 and 2 into a single cursor.. then...

SELECT * FROM table1 INTO CURSOR myCursor ;
WHERE id > "" ;
UNION ALL SELECT * FROM table2 WHERE id > "" ;
ORDER BY id

Rushmore optimisation needs a FOR class or a where class in which some key fields are tested in an acceptable way.



ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[rgbean]

To get optimization, both tables would need an index on the id field.

Rick

 

[adamocean]

"To get optimization, both tables would need an index on the id field.

Rick"

Both fields are, that's what I don't get?

 

[rgbean]

Are you running with SET DELETED ON? Do you also have an index on DELETED() in both tables?

Rick