Have you had to optimize database operations or queries?

Yes, optimizing database operations and queries is an important part of work, especially when dealing with large volumes of data or complex systems.

Main approaches to optimization:

• Analysis and optimization of SQL queries: using EXPLAIN and EXPLAIN ANALYZE to understand the execution plan, eliminating full table scans, adding indexes.
• Indexing: creating appropriate indexes (B-tree, GiST, GIN, etc.) to speed up searches.
• Caching: using caching at the application or database level.
• Denormalization: in some cases, denormalized tables can be used to speed up reads.
• Transaction optimization: minimizing lock hold times, proper use of isolation levels.

Example of query optimization in Java using JDBC:

String sql = "SELECT * FROM orders WHERE customer_id = ?";
try (PreparedStatement stmt = connection.prepareStatement(sql)) {
    stmt.setInt(1, customerId);
    try (ResultSet rs = stmt.executeQuery()) {
        while (rs.next()) {
            // process result
        }
    }
}

If the query runs slowly, you can add an index on the customer_id field in the database:

CREATE INDEX idx_orders_customer_id ON orders(customer_id);

This will significantly speed up the selection by this field.