当使用静态SQL时,执行sql语句的准备步骤是在应用程序执行之前就进行的,因此可在运行时取得更好的性能。
With static SQL, the preparation steps for executing a SQL statement occur before the application is ever executed, thus offering the opportunity for better performance at runtime.
在表上执行一条select语句就可以取得队列中的消息,而执行表上的insert语句就可以发送消息。
Performing a SELECT statement on the table fetches the messages in the queue, and and doing an INSERT statement on the table sends the message.
相对于带注释的模式分解,这种使用xmltable函数的insert语句的优点是,如果分解比较简单,并且目标表的数量不多,这种方法通常可以取得更好的性能。
The advantage of the insert statements with the XMLTABLE function over the annotated schema shred is generally better performance if the shredding is simple and the number of target tables is small.
应用推荐