Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2003
    Location
    London
    Posts
    3

    Unanswered: Sybase Views & Performance

    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.

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    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.
    Thanks,

    Matt

  3. #3
    Join Date
    Feb 2003
    Location
    London
    Posts
    3
    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.

  4. #4
    Join Date
    Feb 2003
    Location
    London
    Posts
    3

    Cool

    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.......]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •