阅读背景:

如果一个表包含大量未使用的/未选中的列,是否会影响性能?

来源:互联网 

Background: I have a table called cars that holds a lot of used cars, aprox 1 million rows. The table has a little more than 170 columns. The table is indexed on individual columns alone. Most of the columns are booleans (e.g. has_automatic_gearbox etc.) and the rest is strings and numbers (e.g. color and price). The cars are shown in a view, where i use around 80 columns out of the total 170. I have a table called cars that hol




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: