该编译过程牵涉到授权检查、优化,以及将语句转化为可执行格式时所需的其他一些活动。
This compilation process involves authorization checking, optimization, and other activities necessary to convert the statement into an executable form.
准备好的语句可重新编译,从而获得更好的性能,在您反复执行同一操作时,它非常方便。
Prepared statements are recompiled for better performance and are convenient when you need to do the same thing over and over again.
Ceylon还确认(在编译时)switch语句包含详尽的实例测试列表,至少包含else子句,从而提供完整的覆盖范围。
Ceylon also ensures (at compile time) that the switch statement contains an exhaustive list of instance tests or, at a minimum, an else clause to provide complete coverage.
在编译语句时,语句的访问计划被存储在包缓存中。
When the statement is compiled, its access plan is stored in the package cache.
如果在编译时一个SQL语句的语法是完全已知的,那么这个语句就称为静态 SQL。
When the syntax of an SQL statement is fully known at compile time, the statement is referred to as static SQL.
常常希望只准备和编译UPDATE语句一次,然后在每次执行更新时传递一个新值。
Often you will want to prepare and compile the UPDATE statement only once, and then pass in a new value every time you execute the update.
如果连接失败,或者该表已删除,那么每次重新声明这个表时,都需要重新编译引用DGTT的任何语句。
If the connection is lost or the table is dropped, any statement referring to the DGTT needs to be recompiled every time the table is re-declared.
当执行预编译语句时,IDS检测底层对象的变化,必要时重新准备(重新编译)语句。
When you execute a prepared statement, IDS now detects changes to underlying objects and re-prepares (re-compiles) the statement if needed.
由于存储过程是在创建时便在服务器上编译了,因此它比单个sql语句执行得更快。
Because a stored procedure is compiled on the server when it is created, it executes faster than individual SQL statements.
存储过程于创建时在服务器上进行编译,所以执行起来比单个SQL语句快。
The stored procedure is compiled on the server when it is created, so it executes faster than individual SQL statements.
数组类型的变量有三个重要的限制:数组长度固定不变,在编译时必须知道其长度,数组只在定义它的块语句内存在。
A variable of array type has three important limitations: Its size is fixed, the size must be known at compile time, and the array exists only until the end of the block in which it was defined.
数组类型的变量有三个重要的限制:数组长度固定不变,在编译时必须知道其长度,数组只在定义它的块语句内存在。
A variable of array type has three important limitations: Its size is fixed, the size must be known at compile time, and the array exists only until the end of the block in which it was defined.
应用推荐