>>Because of sorting for display purposes.
>
>If you also use an index to decide what child records to show, then there is a conflict. If this is the case, you are better off if you use a parameterized view for the child records. Then you would have no trouble in creating temporary indices - which would, by the way, be created much faster, for you are only indexing the records that are shown.

Very good point and a solution.