Date: Thu, 26 Jun 2008 10:11:04 -0700 (PDT)
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