regarding sql querry



IBM's flagship relational database management system

regarding sql querry

Postby pradeepgowda » Tue Apr 06, 2010 6:20 pm

how do we come to know whether the sql querry we have written is an optimised sql querry
pradeepgowda
 
Posts: 40
Joined: Mon Jan 04, 2010 4:17 pm
Has thanked: 0 time
Been thanked: 0 time

Re: regarding sql querry

 

Re: regarding sql querry

Postby dick scherrer » Wed Apr 07, 2010 12:09 am

Hello,

By the amount of resources needed to execute the query.

Suggest you work with your dba or a senior developer on your project.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: regarding sql querry

Postby Anuj Dhawan » Sun Apr 25, 2010 11:06 am

You might like EXPLAIN the query also.
Anuj
Anuj Dhawan
 
Posts: 274
Joined: Mon Feb 25, 2008 3:53 am
Location: Mumbai, India
Has thanked: 6 times
Been thanked: 4 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post