develog

[Oracle] function-based index 조회 본문

DB/Oracle

[Oracle] function-based index 조회

냐옴 2016. 2. 4. 10:18

SELECT *

FROM USER_IND_EXPRESSIONS

;


SELECT *

FROM USER_INDEXES

WHERE 1=1

AND INDEX_TYPE LIKE 'FUNCTION-BASED%'

;



'DB > Oracle' 카테고리의 다른 글

[Oracle] Trigger, enable, disable  (0) 2016.05.13
[Oracle] RECYCLEBIN, 휴지통 비우기  (0) 2016.02.04
[Oracle] SYSTIMESTAMP time zone  (0) 2016.02.03
[Oracle] time zone, utc, local time  (0) 2015.11.02
[Oracle] time zone  (0) 2015.11.02
Comments