OracleDB - ykyki

OracleDB

Memo

SQL Language Reference, 19c

pdf: https://docs.oracle.com/cd/F19136_01/sqlrf/sql-language-reference.pdf

web: https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf

ja, pdf: https://docs.oracle.com/cd/F19136_01/sqlrf.pdf

ja, web: https://docs.oracle.com/cd/F19136_01/sqlrf

ヒント句の構文定義もこっち

Database PL/SQL Language Reference, 19c

pdf: https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/database-pl-sql-language-reference.pdf

web: https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/index.html

SQL Language Quick Reference, 19c

pdf: https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlqr/sql-language-quick-reference.pdf

web: https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlqr

SQL Tuning Guide, 19c

pdf: https://docs.oracle.com/cd/F19136_01/tgsql/sql-tuning-guide.pdf

web: https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql

ja, web: https://docs.oracle.com/cd/F19136_01/tgsql/index.html

ja, pdf: https://docs.oracle.com/cd/F19136_01/tgsql.pdf

ヒント句の使い方はこっち

実行計画の見方

https://use-the-index-luke.com/ja/sql/explain-plan/oracle/operations

http://www.juliandyke.com/Optimisation/Operations/Operations.php