Hi Rick

Changed, thanks :)

There are foreign keys for all the joined items. However ClientStock
seems to refuse to use its. I also note the plan is now just using the
STOCKLEVEL_REGIONREF index instead or STOCKLEVEL_PK (RegionRef,
ItemRef). Performance seems unchanged.

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



Rick DeBay wrote:

> Change ConsignRef to TableName.ConsignRef, it'll help the planner.
> Are there foreign keys for all the items in the join constraints?
>
> Rick DeBay
>
>