-- Note: Assumes connection as 'booklib_user'. -- Index on foreign key columns in the books table CREATE INDEX idx_books_author_id ON books(author_id); CREATE INDEX ...