So I am trying to optimize this query so it can run more efficient... I feel that the nested query is what is really dragging the time on. Any suggestions to optimize it?
asked 30 Jun '10, 15:09 chipShot |
What SQL Anywhere version are you running? Can you post a graphical plan with statistics of the query, along with the CREATE TABLE statements for the 3 tables involved? I also note you are using the "dbo" userid - this isn't recommended. The "dbo" user is used as a system userid in SQL Anywhere that has fewer restrictions than SYS. answered 30 Jun '10, 16:35 Glenn Paulley |
Did you find a resolution? (the background nanny process called "Community" has popped this question to the top)