[nwoolley]

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.

[MattR]

What is the query plan for the queries you are running?

Views are nothing but SQL statements, so there is nothing to tune outside of the SQL.

[nwoolley]

Originally posted by MattR
What is the query plan for the queries you are running?

I am not at work at the moment so I cannot tell you

Views are nothing but SQL statements, so there is nothing to tune outside of the SQL.

I know that they are just SQL statements, I was looking for more general tips on performance enhancement.

[nwoolley]

I have sorted it now I put a new part in the where clause that uses the key on the source table and all is well.......]