>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?
Maybe...
AND (table1.field1 > table1.field2 )=.t.
...since you have an index on that expression, it should constitute a side of a relation expression, as the book says. I know this sounds silly, like most of the other things I'm writing today (west wind? sun spots? I'm under influence of myself? Who knows.), but shouldn't take long to try.