The Property Optimizer is a tool that you can use to optimize, or expose, a Single Value property so that the property values are stored as a column in a database table, in addition to the Storage Stream BLOB. Optimizing a property improves the efficiency of data retrieval for reporting.
The Property Optimizer tool creates an exposed column or a declarative index, changes the database schema, and populates the new column or table with values for existing class instances.