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????