Performance tuning - finding problem statements

[Stephen Gutknecht (SAPDB)]

Title: Message

 

Anyone have tips to share in how to find problem select/update WHERE clauses?  I am wanting to make sure I haven't overlooked some out of the way query that is missing an index.

 

I'm on SAPDB 7.4, Windows 2000.

 

Thanks.