>I am trying to determine why my SQL statement is returning
>'Partial' Optimization instead of full.
>
>SELECT Acctnum, DeptNum;
> FROM Chg;
> WHERE Chg.Acctnum='5555555';
> INTO CURSOR cResult
Patrick, in my experiments with this very issue, I have found that the optimization will be "partial" if any of the fields in the select statement are not in an index. In your example, AcctNum is indexed, but the query processor still has to go back to the main table to retrieve DeptNum. That's why the optimization is partial. If the entire query can be resolved by the contents of the index, then optimization will be "full".
Like I said, this is my empirical observation only... I could certainly be wrong.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only