📄 oracle常见问题常用技巧-6.htm
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#000000" text="#FFFFFF">
COUNT(1)
<p>----------</p>
<p>6427</p>
<p>Execution Plan</p>
<p>----------------------------------------------------------</p>
<p>0 SELECT STATEMENT Optimizer=CHOOSE (Cost=384 Card=1 Bytes=11)</p>
<p>1 0 SORT (AGGREGATE)</p>
<p>2 1 TABLE ACCESS (BY INDEX ROWID) OF 'T_MYTABS' (Cost=384 Card</p>
<p>=126 Bytes=1386)</p>
<p>3 2 INDEX (RANGE SCAN) OF 'I_MYTABS2' (NON-UNIQUE) (Cost=11</p>
<p>Card=126)</p>
<p>Statistics</p>
<p>----------------------------------------------------------</p>
<p>172 recursive calls</p>
<p>1 db block gets</p>
<p>5054 consistent gets</p>
<p>2206 physical reads</p>
<p>0 redo size</p>
<p>293 bytes sent via SQL*Net to client</p>
<p>359 bytes received via SQL*Net from client</p>
<p>2 SQL*Net roundtrips to/from client</p>
<p>5 sorts (memory)</p>
<p>0 sorts (disk)</p>
<p>1 rows processed</p>
<p> <br>
</p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -