Instead of storing metadata across 18 tables, the PODS4 upload process saves it using DB2 columns of type XML and does an INSERT query into four tables.
PODS4上传过程并不在18个表中存储元数据,而是使用xml类型的DB 2列保存元数据,只需对四个表执行INSERT。
We discovered that there is a point where aggregate index costs—more-expensive INSERT and DELETE operations, for example—outweigh a new index's query speed-up benefit.
我发现有一个聚合索引成本的点 —例如,更为昂贵的INSERT和DELETE操作 —超出一个新索引的查询加速所能带来的效益。
This query tests that every stored procedure is prefixed with "usp_" followed by "Insert", "Update", "Delete", or "Select", followed by at least one entity name.
此查询测试每个存储过程是否以“usp_”开头,后跟“Insert”、“Update”、“Delete”或“Select”,然后跟至少一个实体名称。
This must be done carefully, however, because too much free space will mean an abundance of index pages, which could negatively impact query performance and even insert processsing itself.
所以这样做时要小心,不过,太多的自由空间意味着大量的索引页,这对查询的性能乃至insert 处理本身都会产生负面影响。
This must be done carefully, however, because too much free space will mean an abundance of index pages, which could negatively impact query performance and even insert processsing itself.
所以这样做时要小心,不过,太多的自由空间意味着大量的索引页,这对查询的性能乃至insert 处理本身都会产生负面影响。
应用推荐