Tuning - Index
Oracle/Tuning / 2010. 3. 26. 11:33
> create index idx_student_name
on student name);
> select table_name.index_name
from user_ind_columns
where thable_name='STUDENT';
> select name from student;
> select name from student
where name > '0'; => 인덱스를 사용하게 만드는 줄
> select /=+ index_desc(s_idx_student_name) */ name
from student
where name > '0';
> select /*+ index_desc(s_idx_student_name) */ name
from student s
where name > '0'
and rownum=1;
'Oracle > Tuning' 카테고리의 다른 글
| Tuning - Instance Tuning (0) | 2010.03.30 |
|---|---|
| Tuning - 최적 경로 계산 (0) | 2010.03.29 |
| Tuning - SQL Trace (0) | 2010.03.24 |
| Tuning - SQL 처리 구조 & Autotrace (0) | 2010.03.23 |
| Tuning (0) | 2010.03.22 |