Jess,

>I think Filtered Index will do for that matter.

>INDEX ON itemid TAG itemid FOR DELETED()
>SET ORDER TO itemid

The SET RECYCLE option has nothing to do with any itemid, It only consernes records where the deleted flag is set. it should only contain info about which records are deleted. info about any field only takes up valuable diskspace.

Walter,