Alan McDonald wrote:

>
> But I'd still like to know the syntax for incorporating a plan (which has
> more than one index nominated) in a select statement.

Plan belongs to a select expression. In other words, this means a subquery.

> What is the correct syntax?

SELECT ...
, (SELECT COUNT(*) FROM ERSCONTRACTORALERTS
WHERE ERSCONTRACTORALERTS.FKCONTRACTOR=ERSCONTRACTOR.ID
PLAN (ERSCONTRACTORALERTS INDEX (...)) ) AS ALERTCOUNT
, (SELECT COUNT(*) FROM ERSJOB
WHERE ERSJOB.FKCONTRACTOR=ERSCONTRACTOR.ID AND ERSJOB.COMDATE
IS NULL
PLAN (ERSJOB INDEX (...)) ) AS INCOMPJOBS

...
FROM ERSCONTRACTOR
WHERE ...
PLAN (ERSCONTRACTOR INDEX (...))


Dmitry