Page 1 of 1

regarding sql querry

PostPosted: Tue Apr 06, 2010 6:20 pm
by pradeepgowda
how do we come to know whether the sql querry we have written is an optimised sql querry

Re: regarding sql querry

PostPosted: Wed Apr 07, 2010 12:09 am
by dick scherrer
Hello,

By the amount of resources needed to execute the query.

Suggest you work with your dba or a senior developer on your project.

Re: regarding sql querry

PostPosted: Sun Apr 25, 2010 11:06 am
by Anuj Dhawan
You might like EXPLAIN the query also.