You need not to optimize the properties CaseID (pyID) and the operator ID (pyUserIdentifier) as these are Pega properties and were exposed in the respective tables. You should optimize only the properties that were created by you as these are in the BLOB. This data is exposed in the specific tables case and operator tables. I think for your requirement you should join the work table with the operator table with the condition (pyUserIdentifier is equal to Work.pxCreateOperator). Please find the doc for your reference which has the detailed steps.