I have a view created with synatax like the following:
CREATE SQL VIEW myView AS;
SELECT table.field1, table1.field2, table2.field1,;
table1.field1-table1.field2 as calc;
FROM table1,table2;
WHERE table1.fk = table.pk;
AND table1.field1 > table1.field2
I have indexes on the fields used in the join, and an index on table1.field1 > table1.field2.
This view runs extremely slowly, and SQL Showplan shows that there is no optimization on either table.
What else can I do to speed this up?
Erik Moore
Clientelligence