Hi Sasa,

>So, is there some solution to create index on view or master and
>detail table which will be used by view or how to speed up this
>sample if I have 50000 master records and 800000 detail records.

Apart from a index in detail.ID , since you have NO WHERE clause, I don't
think there's much to do.


Regards,
Anderson