>dawa, thanks for the response. unfortunately that didn't change the optimization of the code. it still has "none" listed for rushmore. set deleted's current setting was off as well.
>
>paul
Remember, SET DELETED is scoped to the current data session. So if your form is in private data session, it may have set deleted on in that session.
Is SET OPTIMIZE ON?
Is type_number indexed?
If not, add an index with the expression of type_number. If type_number is a charater type and you use index expression like upper(type_number) then your where clause should use upper(type_number) instead of type_number for the rushmore optimization to kick in.
By the way, I'm leaving the office right now. So you may not hear from me till tomorrow.
HTH
Dawa Tsering
"Do not let any unwholesome talk come out of your mouths,
but only what is helpful for building others up according to their needs,
that it may benefit those who listen."
- Ephesians 4:29-30 NIV
Dare to Question -- Care to Answer
Time is like water in a sponge, as long as you are willing you can always squeeze some.
--Lu Xun, Father of Modern Chinese Literature