PHP에서 Oracle 데이터베이스 뷰 및 인덱스를 사용하는 방법

CREATE VIEW employees_view AS
SELECT employee_id, first_name, last_name, department_id
FROM employees
WHERE department_id = 100;

$conn = oci_connect('username', 'password', 'localhost/XE');
if (!$conn) {
   $e = oci_error();
   trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}

$sql = "SELECT * FROM employees_view";
$stid = oci_parse($conn, $sql);
oci_execute($stid);

while ($row = oci_fetch_assoc($stid)) {
   echo $row['EMPLOYEE_ID'] . ", " . $row['FIRST_NAME'] . ", " . $row['LAST_NAME'] . ", " . $row['DEPARTMENT_ID'] . "<br>";
}

oci_free_statement($stid);
oci_close($conn);

CREATE INDEX idx_name ON employees (first_name, last_name);

$conn = oci_connect('username', 'password', 'localhost/XE');
if (!$conn) {
   $e = oci_error();
   trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}

$sql = "SELECT * FROM employees WHERE first_name = :first_name AND last_name = :last_name";
$stid = oci_parse($conn, $sql);

$firstName = 'John';
$lastName = 'Doe';

oci_bind_by_name($stid, ":first_name", $firstName);
oci_bind_by_name($stid, ":last_name", $lastName);

oci_execute($stid);

while ($row = oci_fetch_assoc($stid)) {
   echo $row['EMPLOYEE_ID'] . ", " . $row['FIRST_NAME'] . ", " . $row['LAST_NAME'] . ", " . $row['DEPARTMENT_ID'] . "<br>";
}

oci_free_statement($stid);
oci_close($conn);