Sorry to keep asking almost the same thing - but I think I'm finally understanding.

If I have a view with 2 tables with Address indexed on iCounrty and iID.

SELECT Address.iid, Address.maddress, Address.mstreet, Address.ccity,;
  Address.ccounty, Address.cpostcode, Address.nssc, Address.llondon,;
  Country.cname, Address.icountry;
 FROM  ash!address LEFT OUTER JOIN ash!country ;
   ON  Address.icountry = Country.iid;
 WHERE Address.iid = ?ThisForm.Address

Using index tag Id to rushmore optimize table address
Rushmore optimization level for table address: full
Rushmore optimization level for table country: none
Joining table address and table country using index tag Id

This is reporting the Address table is fully optimised while the Country is not optimised. Could this view be better optimise or is this all I should be aiming to achieve?

Many thanks for any explanations.
Caroline