??η??????????????????Index??
???????? ???????[ 2016/10/10 11:16:19 ] ???????????? ?????
????????Index?????????????????????????????????????????????????д??????????????????????????д????????????д????е?????????????????????
?????????5??????????????????????????????????????????????磬??????????????????????????????
????-- ??????
????CREATE INDEX ON customer (first_name);
????-- 5???
????CREATE INDEX ON customer (first_name?? last_name);
????????????????????????????
??????η???????????????
????????????Oracle?????????????????????????????????????α? ???? ????????κβ???????:
SELECT sql_fulltext
FROM v$sql
WHERE sql_id IN (
SELECT sql_id
FROM v$sql_plan
WHERE (object_owner?? object_name)
= (('OWNER'?? 'IDX_CUSTOMER_FIRST_NAME'))
)
ORDER BY sql_text;
?????????????????????????α???? ???? ?е?????SQL???V$SQL????????????????????????α? ???? ?м????????κ??з???????????м??????V $ sql_plan????
??????????????????????????????????????????κ??У??????ó???????????????????????????????
???????????????????????????????????????????????????:
???????м???????г????в????v$sql_plan?????????????
SELECT owner?? index_name
FROM all_indexes
WHERE owner = 'OWNER'
AND (owner?? index_name) NOT IN (
SELECT object_owner?? object_name
FROM v$sql_plan
WHERE object_owner IS NOT NULL
AND object_name IS NOT NULL
)
ORDER BY 1?? 2
????????????????????????????????????????????б???ù???
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11