Oracle Optimization Technology

1. Partitioning technology

2. Indexing technology

3. Temporary table Technology

--Create a transaction-level temporary table, the data will be lost after commit, but the table structure still exists
CREATE GLOBAL Temporary TABLE Admin_work_area
(StartDate DATE,
EndDate DATE,
Class CHAR (20))
On COMMIT DELETE ROWS;

--Create session-level temporary tables where the data is lost after the session but the table structure still exists
CREATE GLOBAL Temporary TABLE admin_work_area (
StartDate DATE,
EndDate DATE,
Class CHAR (20))
On COMMIT PRESERVE ROWS;
--Create an index first, otherwise the index will not be created after inserting the data
Create INDEX T_index on Admin_work_area (startdate);

INSERT into Admin_work_area values (Sysdate,sysdate, ' session temperary ');
SELECT * from Admin_work_area;
Commit

--Truncate before you can delete data
TRUNCATE TABLE Admin_work_area;
drop table Admin_work_area;