Where절에 사용하는 인덱스

DB CAFE

Dbcafe (토론 | 기여)님의 2022년 12월 3일 (토) 00:32 판
(차이) ← 이전 판 | 최신판 (차이) | 다음 판 → (차이)

추천메뉴 바로가기

DBA { Oracle DBA 명령어 > DBA 초급 과정 > DBA 고급 과정 }
튜닝 { 오라클 튜닝 목록 }
모델링 { 데이터 모델링 가이드 }

select *
from sys.col_usage$;

select *
from sys.ind_usage$;

select *
from dba_objects
where owner = 'TEST'
and object_name = 'T1';

select *
from sys.col_usage$
where obj#= 493734;

1 user 별[편집]

select a.username, o.name oname, c.name cname,
    u.equality_preds,
    u.equijoin_preds, u.nonequijoin_preds,
    u.range_preds, u.like_preds, u.null_preds,
    to_char(u.timestamp,'yyyy-mm-dd hh24:mi:ss') as when
from sys.col_usage$ u, sys.obj$ o, sys.col$ c, all_users a
where a.user_id = o.owner#
  and u.obj# = o.obj#
  and u.obj# = c.obj#
  and u.intcol# = c.col#
  and a.username = 'TEST'
  order by a.username, o.name, c.name
;

2 User , table 별[편집]

select a.username, o.name oname, c.name cname,
    u.equality_preds,
    u.equijoin_preds, u.nonequijoin_preds,
    u.range_preds, u.like_preds, u.null_preds,
    to_char(u.timestamp,'yyyy-mm-dd hh24:mi:ss') as when
from sys.col_usage$ u, sys.obj$ o, sys.col$ c, all_users a, dba_objects do
where a.user_id = o.owner#
  and u.obj# = o.obj#
  and u.obj# = c.obj#
  and u.intcol# = c.col#
  and a.username = 'TEST'
  and a.username = do.owner
  and do.object_name = 'T1'
  and DO.OBJECT_ID = O.OBJ#
  order by a.username, o.name, c.name
;

원본 주소 "http://dbcafe.co.kr/wiki/index.php?title=Where절에_사용하는_인덱스&oldid=6787"

Oracle