AGIT Interview Question

How so you solve database performance issue