danmainah/clinic-database

clinic-database

First query

SELECT COUNT(*) FROM visits where animal_id = 4;

Solution:

Added index on the animal_id column in the visits table.

CREATE INDEX animal_id ON visits (animal_id);

Before:

After:

Second query

SELECT * FROM visits where vet_id = 2;

Solution:

Added index on both the animal_id and vet_id columns in the visits table.

CREATE INDEX vet_animal ON visits (vet_id, animal_id);

Before:

After:

Third query

SELECT * FROM owners where email = 'owner_18327@mail.com';

Solution:

Added index on email column in the owners table.

CREATE INDEX email_id ON owners (email);

Before:

After: