1·The pros include compact tables (no unnecessary nullable columns), data partitions across three subclass tables and easy association with other tables using the top super class table.
优点包括数据表比较紧凑(没有不需要的可空字段),数据跨三个子类的表进行分区,容易使用超类的表与其他表进行关联。
2·If you use a nullable VARCHAR column and only ASCII characters (UTF-8 format 1 byte per character) involved, the maximum character length that can be indexed is 1021 characters.
如果使用可空的varchar列并只涉及ASCII字符(在utf - 8格式中每字符1字节),那么可以建立索引的最大字符长度是1021个字符。
3·For example, when you create a nullable VARCHAR (1024) column in a Unicode database and then create an index on VARCHAR (1024) column. You will encounter the following error.
例如,在Unicode数据库中创建一个可空的VARCHAR(1024)列,然后在这个VARCHAR(1024)列上创建索引。