[TIBERO] 인덱스 추가 시, Plan변화 TEST

1. Table 생성 create tablespace USER_TEST01 datafile 'TS_USER_TEST_01.dtf' size 2G; create user test_user01 identified by "test01#$" default tablespace USER_TEST01; grant connect, resource to test_user01; --drop table test_user01.test01; create table test_user01.test01 (c1 number, c2 number, c3 varchar2(10) ) nologging; 2. 50만건 insert DECLARE TYPE tbl_ins IS TABLE OF test_user01.test01%ROWTYPE IND..

• format_list_bulleted Database/Tibero
• · 2023. 5. 4.
• textsms

[MYSQL] PLAN 확인 방법 (예측, 실제계획)

사용법 1. EXPLAIN SQL 구문 2. DESCRIBE SQL구문 3. DESC SQL 구문 -. 위 3구문 전부 동일한 결과가 나온다 mysql> explain -> SELECT * FROM test1.test_tab1 tt -> WHERE c1 BETWEEN 1 and 10; +----+-------------+-------+------------+------+----------------------+------+---------+------+------+----------+-------------+ | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra..

• format_list_bulleted Database/MYSQL
• · 2022. 11. 1.
• textsms