File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
order of condition is important
Joined: Jul 18, 2012
Jun 20, 2014 10:20:48
FROM EMPLOYEE EMP,DEPARTMENT DEPT
Here in where clause is the order of condtion ie
DEPT.DEPTID = EMP.EMPDEPID
Is important ?
author & internet detective
Joined: May 26, 2003
Jun 20, 2014 21:07:47
No. The database will optimize your query the same way regardless of which order you type those in.
OCA 8 book
How To Ask Questions The Smart Way
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
I agree. Here's the link:
subject: order of condition is important
Question related to order of elements inside Servlet element in DD
Set And List
Help regarding getting values based on keys in HashMap
Ordering in DD (web.xml)
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015