SQL性能分析

设置测试
CREATE USER spa_test_user IDENTIFIED BY spa_test_user
QUOTA UNLIMITED ON users;
GRANT CONNECT, CREATE TABLE TO spa_test_user;


CREATE TABLE my_objects AS
SELECT * FROM all_objects;

EXEC DBMS_STATS.gather_table_stats(USER, ‘MY_OBJECTS’, cascade => TRUE);

SELECT COUNT() FROM my_objects WHERE object_id <= 100;
SELECT object_name FROM my_objects WHERE object_id = 100;
SELECT COUNT() FROM my_objects WHERE object_id <= 1000;
SELECT object_name FROM my_objects WHERE object_id = 1000;
SELECT COUNT(*) FROM my_objects WHERE object_id BETWEEN 100 AND 1000;



















CREATE INDEX my_objects_index_01 ON my_objects(object_id);

EXEC DBMS_STATS.gather_table_stats(USER, ‘MY_OBJECTS’, cascade => TRUE);