>Sorry i mean : while creating the view in my project i have set an order by in the 'order by' tab in the view designer.

I see. That's not what I meant. Check for an 'index on' code. What does display status say? Or might it be there is code like?:
go 123

Cetin