regarding sql querry
Previous topic • Next topic • 3 posts
• Page 1 of 1
regarding sql querry
by 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
by 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.
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.
d.sch.
-
dick scherrer - Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
- Has thanked: 3 times
- Been thanked: 93 times
Re: regarding sql querry
by Anuj Dhawan » Sun Apr 25, 2010 11:06 am
You might like EXPLAIN the query also.
Anuj
- Anuj Dhawan
- Posts: 273
- Joined: Mon Feb 25, 2008 3:53 am
- Location: Mumbai, India
- Has thanked: 6 times
- Been thanked: 4 times
Previous topic • Next topic • 3 posts
• Page 1 of 1
-
- Related topics
- Replies
- Views
- Last post
-
- like function Querry
by krishnakumar15 » Tue Jan 06, 2015 2:52 pm - 0 Replies
- 1987 Views
- Last post by krishnakumar15
Tue Jan 06, 2015 2:52 pm
- like function Querry
-
- to retrieve 3 maximum salary in a single querry in db2 v6
by pradeepgowda » Tue Mar 23, 2010 11:38 am - 9 Replies
- 7662 Views
- Last post by GuyC
Thu Apr 08, 2010 4:03 pm
- to retrieve 3 maximum salary in a single querry in db2 v6