Given the number of INSERT, UPDATE, and DELETE operations and changes in data distributions, you need to collect the right statistics regularly and with minimum resource consumption.
您需要根据INSERT、UPDATE和DELETE操作的数目和数据分布的变化,在资源消耗尽量少的情况下定期收集正确的统计数据。
In most cases, well-suited SQL statements are very simple SELECT statements that reference only a single table or are INSERT, UPDATE, and DELETE (UID) operations that are executed many times.
在大多数情况下,非常适合使用参数标记的sql语句要么是非常简单的SELECT语句(只引用一个表),要么是被多次执行的INSERT、UPDATE和DELETE (uid)操作。
You can also perform INSERT, UPDATE, and DELETE operations for relational nicknames, but not for non-relational nicknames.
对于关系昵称,也可以执行INSERT、UPDATE和DELETE操作,但是对于非关系昵称不可以执行这些操作。
In addition, triggers can now contain UPDATE, DELETE, and INSERT operations together in a single clause as the trigger event. For example.
另外,触发器现在可以在单一子句中同时包含UPDATE、DELETE和INSERT操作,作为一个触发器事件。
Since this is a table operation, tooling generates insert, update, and delete operations automatically.
由于这是一项表操作,因此工具将自动生成insert、update和delete操作。
The DBMS ensures that the index is always consistent with the data in the table by updating it during INSERT, UPDATE, and DELETE operations.
通过使用INSERT、UPDATE和DELETE操作对索引进行更新,DBMS能够确保索引始终与表数据一致。
Many factors affect performance during SELECT, INSERT, UPDATE, and DELETE operations. These include.
在执行SELECT、INSERT、UPDATE和DELETE操作时,很多因素都会对性能产生影响。
Write access rules are applied when data is written (INSERT, UPDATE, and DELETE operations) and can be summarized as follows.
当用户写数据时(INSERT UPDATE和DELETE操作),则应用写访问规则,写访问规则可总结如下。
MODIFIES SQL DATA in SQL table functions allows you to push even INSERT, UPDATE, DELETE and MERGE (data-change-operations) into the inner leg of correlated joins.
SQL表函数中的 MODIFIES SQLDATA使您甚至可以将INSERT、UPDATE、DELETE和MERGE ( 数据更改操作)放入到关联连接的内表中。
The informational constraints are not enforced by the federated server during operations such as insert, delete and update.
在诸如insert、delete和update操作期间,联邦服务器不施加信息约束。
Unused and seldom used indexes cause UID operations (UPDATE, INSERT, and DELETE) and database maintenance activities (such as RUNSTATS and REORG) to run unnecessarily long.
未使用和很少使用的索引可能导致UID操作(update、INSERT和DELETE)和数据库维护活动(比如runstats和REORG)的运行时间更长。
They can guard against malicious or incorrect INSERT, UPDATE and DELETE operations and enforce other restrictions that are more complex than those defined with CHECK constraints.
触发器可以预防恶意或错误的INSERT、UPDATE和DELETE操作,并强制执行比CHECK约束中定义的限制更复杂的限制。
They can guard against malicious or incorrect INSERT, UPDATE and DELETE operations and enforce other restrictions that are more complex than those defined with CHECK constraints.
触发器可以预防恶意或错误的INSERT、UPDATE和DELETE操作,并强制执行比CHECK约束中定义的限制更复杂的限制。
应用推荐