The limitations of the missing index feature – It suggests creating indexes on imprecise and not persisted columns

This will be my penultimate blog about the limitations of the missing index feature and this one will be short. Before we start, let us clarify some terms so you can better understand the table we are going to create. The data types real and float are imprecise data types for use with floating point numeric data. Floating point data is approximate; therefore, not all values in the data type range can be represented exactly. Non deterministic columns are computed columns which may return different results each time they are called.