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