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