数据类型和查询速度 [英] Data types and query speed

问题描述

数据类型是否会影响查询速度。在行很少的表中使用smallint instedof int甚至tinyint之类的正确类型有多重要。

Does the type of data has an impact on the speed of queries. How important is to use correct types like smallint instedof int or even tinyint in tables which has small amount of rows.

执行查询

select * from table

推荐答案

它可能会影响性能，例如，数据大小越小，获取它们的速度就越快，它们在磁盘上需要的页面越少。因此，您必须尝试选择尽可能小的尺寸。

It can affect performance, for example, the smaller data size the quicker you can get them, the less pages they reqire on disk. So you have to try to choose type of smallest possible size.

这篇关于数据类型和查询速度的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！