Re: View with an outer join - is there any way to optimise

You should be able to use my trick...the join that is giving you the
problem is:

SELECT *
  FROM
      tokens.ta_tokenhist h INNER JOIN
      tokens.vw_tokens    t ON h.token_id = t.token_id
  WHERE
      h.sarreport_id = 9 ;


ta_tokenhist is already part of your view, right?  So you should be able
to include the sarreport_id as part of your view, and then restructure
your query as:


SELECT *
  FROM
      tokens.ta_tokenhist INNER JOIN
      tokens.vw_tokens ON tokens.ta_tokenhist.token_id =
tokens.vw_tokens.token_id
  WHERE
      tokens.vw_tokens.sarreport_id = 9 ;

I removed the aliases because they confuse me ;)