안녕하세요?

쿼리 짠다고 짰는데.. 너무 느리네요. 3분 정도? 걸려서 ;;

위치를 바꿔 보기도 했는데.. 잘 안되네요.

select  t.table_name,
        pk.index_name,
        t.column_name,
        decode(t.NULLABLE,'N','NOT NULL','') "NULL",
        case data_type
                when 'DATE' then t.data_type
                when 'NUMBER' then t.data_type||'('||t.data_precision||','||nvl(t.data_scale,'0')||')'
                when 'TIMESTAMP(6)' then t.data_type
                when 'BLOB' then t.data_type
                when 'CLOB' then t.data_type
                when 'BFILE' then t.data_type
                when 'LONG' then t.data_type
                else t.data_type||'('||t.data_length||')'
        end data_type,
        t.data_default,
        pk.column_position pk_posi,
        ut.cache,
        ut.buffer_pool
from user_tab_columns t,
     (select i.column_position,i.index_name,i.table_name,i.column_name from user_ind_columns i, user_constraints c
      where i.index_name = c.index_name and c.constraint_type = 'P' ) pk
      user_tables ut
where
      t.table_name = replace('table','\')
  and t.table_name = pk.table_name(+)
  and t.table_name = ut.table_name
  and t.column_name = pk.column_name(+)
order by t.table_name,t.column_id;

잘 부탁드립니다 ㅠ