aspose file tools*
The moose likes JDBC and the fly likes Whats the Importance Of Sequence Of Conditions In an Sql Query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Whats the Importance Of Sequence Of Conditions In an Sql Query" Watch "Whats the Importance Of Sequence Of Conditions In an Sql Query" New topic
Author

Whats the Importance Of Sequence Of Conditions In an Sql Query

Chetan M
Ranch Hand

Joined: Dec 18, 2002
Posts: 43
How does sequence/order Of Conditions In an Sql Query matters 4 performance or execution time


No matter how much you know today, you will have to know more tomorrow.<br /> Hakunamatata !!!
Neeraj Kumar Mishra
Greenhorn

Joined: May 22, 2002
Posts: 9
Hi,
It does matters...in a sequence of conditions in a sql each next call has to wait for the previous one so the performance of the query goes down and it becomes worse if u are using a simple statement for the query...if u want to know more just tell me what exactly u want to know...
Regards...
Neeraj
Marilyn de Queiroz
Sheriff

Joined: Jul 22, 2000
Posts: 9047
    
  10
Chetan M,

Unfortunately your name does not comply with the Javaranch naming policy. A last initial is not sufficient. You need to have a first name, a space, and a last name. Please change your display name. Thank you.


JavaBeginnersFaq
"Yesterday is history, tomorrow is a mystery, and today is a gift; that's why they call it the present." Eleanor Roosevelt
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Whats the Importance Of Sequence Of Conditions In an Sql Query