Skip to main content

02A

2023λ…„ 12μ›” 27일About 1 minOracle DBcrashcourseoracleoracle-dboracle-sql

02A κ΄€λ ¨


μš©μ–΄


Index κ΄€λ ¨ 자료

Function-based Index

Index Skip Scanning

https://oracle-base.com/articles/9i/index-skip-scanning http://dba-oracle.com/t_oracle_index_skip_scan_tips.htm http://www.orafaq.com/tuningguide/index%20skip%20scan.html https://stackoverflow.com/questions/19059444/index-range-scan-vs-index-skip-scan-vs-index-fast-full-scan


partition table κ΄€λ ¨ 자료

http://12bme.tistory.com/290 http://energ.tistory.com/entry/Oracle-Partition-table-%EC%A2%85%EB%A5%98 http://www.dbguide.net/db.db?cmd=view&boardUid=13828&boardConfigUid=9&boardIdx=73&boardStep=1 http://support.dbworks.co.kr/index.php?document_srl=2751&mid=ora_tb

index organized table

https://oracle-base.com/articles/8i/index-organized-tables https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables012.htm#ADMIN01506 https://m.blog.naver.com/PostView.nhn?blogId=whdahek&logNo=220796458477&proxyReferer=https%3A%2F%2Fwww.google.co.kr%2F\


Random Access κ΄€λ ¨ 자료

http://www.gurubee.net/lecture/2230 http://www.gurubee.net/lecture/2235 http://sorasora.tistory.com/60 http://blog.naver.com/PostView.nhn?blogId=bb_&logNo=220902149310&redirect=Dlog&widgetTypeCall=true

Selectivity

https://jdm.kr/blog/169 http://www.dbguide.net/dbqna.db?cmd=view&boardConfigUid=30&boardUid=145437 http://wiki.gurubee.net/pages/viewpage.action?pageId=1507544 http://ojc.asia/bbs/board.php?bo_table=LecOrccleTun&wr_id=85

Transitivity

http://docs.openlinksw.com/virtuoso/transitivityinsql/ http://www.dba-oracle.com/t_sql_tuning_transitive_closure.htm https://stackoverflow.com/questions/18100621/how-to-find-matching-pairs-with-transitivity-of-equality-in-ms-sql https://medium.com/@mauridb/transitive-closure-clustering-with-sql-server-uda-and-json-dade18953fd2


View

https://oracle-base.com/articles/misc/materialized-views

DBMS_XPLAN

10046 Trace

ADVANCED ALLSTATS LAST



μ‹€ν–‰κ³„νš μ’…λ₯˜


이찬희 (MarkiiimarK)
Never Stop Learning.