아래처럼 처리하면 쿼리를 병렬로 처리가능하다. 대신에 함수선언시 위에 처럼 선언해야 한다.
- Cache and parallel are only in oracle enterprise editions
https://docs.oracle.com/database/121/DBLIC/editions.htm#DBLIC116
Licensing Information
ANTLR Antlr ANTLR 3 License [The BSD License] Copyright (c) 2003-2007, Terence Parr All rights reserved. Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: Redistri
docs.oracle.com
'Database > PLSQL' 카테고리의 다른 글
| 073 - [Oracle PL/SQL] DETERMINISTIC hint (0) | 2024.04.10 |
|---|---|
| 072 - [Oracle PL/SQL] RESULT_CACHE hint (0) | 2024.04.10 |
| 070 - [Oracle PL/SQL] NOCOPY - 성능차이. (0) | 2024.04.10 |
| 069 - [Oracle PL/SQL] NOCOPY 예외상황 (0) | 2024.04.10 |
| 068 - [Oracle PL/SQL] NOCOPY (0) | 2024.04.10 |
