要提高查询速度,数据的格式应该尽可能与数据被使用时的格式接近。
To improve queries speed, data's format should be as close as possible to the format it is to be used.
如同在关系数据库中一样,WebSphere eXtreme Scale支持使用索引提高查询速度。
Just as in a relational database, WebSphere eXtreme Scale supports the use of indices to improve the speed of queries.
两个表的 unitID 列上的常规关系索引以及 unit 表的 manager 列上的常规关系索引有助于提高嵌入式 SQL 查询的速度。
Regular relational indexes on the unitID columns of both tables as well as on the manager column in the unit table can help speed up the embedded SQL query.
应用推荐