The INSERT with VALUES is a special case because it would not benefit from executing through SQE because the statement lacks selection criteria, grouping or ordering.
INSERTwithVALUES是一个特例,因为它无法从通过SQE执行中受益,因为该语句没有选择标准、分组或排序。
In order to apply the ordering on all the columns, we will need to add them to the if-then-else statement.
为了对所有列应用排序,需要把它们添加到if - then - else语句中。
For example, changing the ordering of the where clause statement to improve performance helps in certain databases.
例如,更改某些子句的排序可以帮助提高某些数据库的性能。
The Informix implementations of the merge statement allow the flexibility of ordering the WHEN MATCHED and WHEN NOT MATCHED clauses, as shown in Listing 6.
merge语句的Informix实现允许灵活地对WHENMATCHED和WHENNOT matched子句进行排序,如清单6所示。
The Informix implementations of the merge statement allow the flexibility of ordering the WHEN MATCHED and WHEN NOT MATCHED clauses, as shown in Listing 6.
merge语句的Informix实现允许灵活地对WHENMATCHED和WHENNOT matched子句进行排序,如清单6所示。
应用推荐