oracle 假表,请教各位大哥！关于 SQL 语句访问表是否采用假名

感覺

select a.col_1 ,a.col_2 from t_test a where ...

比較好規范

可下列性能一樣的

SQL> ED

已將 檔案 afiedt.buf 寫入

1* SELECT A.CON_NO FROM PDPSCMS A,PDPSCTB B WHERE A.CON_NO=B.CON_NO AND A.CON_NO='Q0304050001'

SQL> /

CON_NO

------------

Q0304050001

Q0304050001

Q0304050001

Q0304050001

Execution Plan

----------------------------------------------------------

0      SELECT STATEMENT Optimizer=CHOOSE (Cost=5 Card=5 Bytes=110)

1    0   NESTED LOOPS (Cost=5 Card=5 Bytes=110)

2    1     INDEX (UNIQUE SCAN) OF 'PK_PDPSCMS8' (UNIQUE) (Cost=2 Ca

rd=1 Bytes=11)

3    1     INDEX (RANGE SCAN) OF 'PDPSCTBWSC' (NON-UNIQUE) (Cost=3

Card=5 Bytes=55)

Statistics

----------------------------------------------------------

0  recursive calls

0  db block gets

7  consistent gets

0  physical reads

0  redo size

409  bytes sent via SQL*Net to client

421  bytes received via SQL*Net from client

2  SQL*Net roundtrips to/from client

2  sorts (memory)

0  sorts (disk)

4  rows processed

SQL> ED

已將 檔案 afiedt.buf 寫入

1* SELECT PDPSCMS.CON_NO FROM PDPSCMS ,PDPSCTB  WHERE PDPSCMS.CON_NO=PDPSCTB.CON_NO AND PDPSCMS.CON_NO='Q0304050001'

SQL> /

CON_NO

------------

Q0304050001

Q0304050001

Q0304050001

Q0304050001

Execution Plan

----------------------------------------------------------

0      SELECT STATEMENT Optimizer=CHOOSE (Cost=5 Card=5 Bytes=110)

1    0   NESTED LOOPS (Cost=5 Card=5 Bytes=110)

2    1     INDEX (UNIQUE SCAN) OF 'PK_PDPSCMS8' (UNIQUE) (Cost=2 Ca

rd=1 Bytes=11)

3    1     INDEX (RANGE SCAN) OF 'PDPSCTBWSC' (NON-UNIQUE) (Cost=3

Card=5 Bytes=55)

Statistics

----------------------------------------------------------

0  recursive calls

0  db block gets

7  consistent gets

0  physical reads

0  redo size

409  bytes sent via SQL*Net to client

421  bytes received via SQL*Net from client

2  SQL*Net roundtrips to/from client

2  sorts (memory)

0  sorts (disk)

4  rows processed

SQL>