invisible index 썸네일형 리스트형 #34_140730_TUNING_INVISIBLE INDEX # INVISIBLE INDEX n 수행 예제SQL> demobld.sqlSQL> create index emp_sal on emp(sal);SQL> alter index emp_sal invisible;SQL> select index_name,visibility from user_indexes;INDEX_NAME VISIBILIT------------------------------ ---------EMP_SAL VISIBLESALES500_RN VISIBLESALES500_CHANNEL_PROFIT VISIBLESALES500_CHANNEL_ID VISIBLESALES500_AMOUNT_SOLD VISIBLE………………………………………………………- invisible 유무 확인SQL> select /*.. 더보기 이전 1 다음