>Hello, I have some questions about rushmore.
>
>Why does SYS 3054(11) say that the optimization level is partial or none when I am joining two tables on integer fields that have indexes? These are ordinary regular indexes.
>

Hans,

If you have SET DELETED ON, SYS(3054) will show that your queries are only partially optimized if you don't have an index on DELETED(). If you will have an index tag on DELETED() they will be shown as fully optimized. But according to recent opinions tag on DELETED() (depending on your data) may make more bad than good.

Check out "OutFoxed" - article#1043 in Articles section, and also "The hidden face of SELECT SQL" - article#85, article#86, article#87. They may give you more info on questions you are asking.