In Grid or outside of it, you can run SQL Tuning Advisor. It'll recommend indexes if it thinks it's necessary. -----Original Message----- From: J. Dex <cemail_219@xxxxxxxxxxx> To: oracle-l@xxxxxxxxxxxxx Sent: Thu, Jan 14, 2010 9:58 am Subject: Checking for indexes Grid Control Isn't there a way in Grid Control (10g) to see what indexes are recommended to improve performance? I can't seem to locate it. Your E-mail and More On-the-Go. Get Windows Live Hotmail Free. Sign up now. =