Optimizing the Execution Plan in an Oracle Database
ADVANCED BIO-INSPIRED COMPUTATIONAL METHODS(2009)
摘要
This paper presents a case study for different methods of optimization the execution plan in Oracle 11g Database with the view to obtaining the shortest time of execution of stored procedures and functions. The testing was made on application of mobile telephony through execution of stored procedure PL/SQL which is processing telephone invoices on a database with a million recordings. Some system parameters have greatly influenced the performance of execution times of stored procedures and functions.
更多查看译文
关键词
database,instance,session,instruction,index
AI 理解论文
溯源树
样例
生成溯源树,研究论文发展脉络