oracle performance tuning tips

of this field is generally not clearly defined and only used for a unique identifier. This field is generally set as a primary key. If the application only targets Oracle, but does not consider database independence, sequence is nothing more than the best choice. For friends who used to use other databases such as MSSQL in the past, it was too difficult to use Oracle. it took a lot of effort to create a se

Tips for using temporary tables in Oracle stored procedures 1. Oracle temporary table knowledge in Oracle, temporary tables are divided into SESSION and TRANSACTION. SESSION-level temporary table data exists throughout the SESSION, the temporary table data at the TRANSACTION level disappears after the TRANACTION ends,

is used, be sure to explicitly delete all temporary tables at the end of the stored procedure, TRUNCATE table first, and then drop table, which avoids longer locking of the system tables.25. Avoid using cursors as much as possible, because cursors are inefficient and should be considered for overwriting if the cursor is manipulating more than 10,000 rows of data.26. Before using a cursor-based method or temporal table method, you should first look for a set-based solution to solve the problem,

Data Query is one of the most important functions in database operations. Sometimes the performance of database queries is directly related to the database operation efficiency and database selection. I will not talk about the principle below, but I will summarize some of the tips that are easy to ignore. Maybe everyone is worried about it? 　First Tip: Use a connector to connect multiple fields. 　　

oracle| Tips 1. Find Useless index: 　　 DML performance is low, one of the most serious reasons is the existence of useless indexes. All SQL inserts, updates, and deletions become slower when they need to modify a large number of indexes when each row of data is changed. Many Oracle managers will assign indexes to an S