there are ways to see out which indexes get used and which are not. It's surprising to find out table scans or incorrect indexes getting used.