English to Romanian Tech/Engineering IT (Information Technology)

Now consider the possible number of values that a CHAR(4) column can assume versus a SMALLINT column. Even if edit checks are coded for the column, SQL Server is not aware of these when determining the access plan for the retrieval SQL. Instead, SQL Server will assume that all permissible characters could be stored in the column. Assuming 26 alphabetic letters, 10 ***numeric digits***, and the space character can be specified, there is a possibility of 37 distinct characters. Therefore, for a four-byte character column there would be 374 or 1,874,161 possible values.