query optimization

From: Garg <sendtogarg_at_gmail.com>
Date: Thu, 26 Jun 2008 10:11:04 -0700 (PDT)
Message-ID: <58ddfaf4-dd9c-435b-b43c-031953632e55@h1g2000prh.googlegroups.com>


Hi,
One is been asked to me on query optimization and the question was, if you have to optimize a sql query which is dealing with 10 tables then tell me how will you go about. I can’t use stored procedures. As I am not a DBA, I am a simple Java developer so I am not having any idea about this so I given a stupid answer of creating a View. Could you please tell me what steps should I take to optimize that query.

Thanks in advance,
Tarun Received on Thu Jun 26 2008 - 12:11:04 CDT

Original text of this message