Вернуться

Листинг 6. Реализация возможности AUTOTRACE

SQL> 	SET AUTOTRACE ON
SQL> 	SELECT COUNT(NAME) FROM EMP7 WHERE NAME = 'BRANCHES';

Output: 
COUNT(NAME)
100

Execution Plan
0		SELECT		STATEMENT Optimizer=CHOOSE 
1		0		SORT (AGGREGATE) 
2		1		INDEX (RANGE SCAN) OF 'EMP7_I1' (NON-UNIQUE)

Statistics
		0	recursive calls
		0	db block gets
		1	consistent gets
		1	physical reads 
		1	sorts (memory)
		0	sorts (disk)
		1	rows processed

Вернуться