I need a question answering about views in Sybase. I have to increase performance on a view that currently pulls data from one main table with joins to other satelite tables. It only pulls 200K rows but even the select count (*) from view takes 12 seconds. I am the only user at the moment as I am doing the development in the dev environment so I need to tune the view's select statement. The view is to be used as a bunch of objects for a Business Objects Universe. Any tips on the tuning of views or selects in general would be most welcome.