Oracle WHERE Clause 🔍

Mentor's Note: The WHERE clause is the "Filter" of your database. It allows you to pick specific needles from the haystack of data based on rules you define. 💡

---

🌟 The Scenario: The Targeted Mailing ✉️

• Goal: You want to send a letter only to employees who earn more than ₹50,000.
• Action: You tell Oracle: "Show me all people WHERE salary > 50000."

---

💻 1. The Basic Syntax

SELECT columns
FROM table
WHERE condition;

Example: Finding a specific Employee ID

SELECT first_name, last_name 
FROM employees 
WHERE employee_id = 101;

---

🏗️ Architect's Note: Indices & Predicates 🛡️

The WHERE clause is where performance is won or lost.

• The Secret: If you filter on a column that has an Index, Oracle can find the row instantly (Index Seek). If there is no index, Oracle must read the entire table (Full Table Scan).
• Architecture Tip: Always aim to filter by the Primary Key or Unique Keys whenever possible for maximum speed.

---

📈 Learning Path

• ← Back: DISTINCT
• Next: AND / OR Operators →