>Thanks, I will try this. I was looking for some kind of properties box in the view designer to indicate there was an index. Do I put this code somewhere in the init method of the report that uses this view.
Yes you can. However, if you're going to use it for report purposes, it's probably not the best way: you may generate report cursor with exact ORDER clause you need in.
Edward Pikman
Independent Consultant