21.08.2015 13:58, 'Louis van Alphen' wrote:

> Dmitry, re your point 4, do you mean:
>
> create view SKIN as
> select
> ID,
> (select NAME from COLOUR_ C where C.ID = S.COLOUR_ID)
> from SKIN_ S;

Right. Not very good option when you need many lookup fields from the
same table, but could still be better than a fullscan inside join plans.


Dmitry