Jim,
fully optimized - means all records that will be in the result set can be determined from the index tags.
partially optimized - means that some data must be read from the table to determine if a record will be in the result set
>So when does the 'partially optimized' mentioned in the docs take effect, and what does it really mean????