• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Whats the Importance Of Sequence Of Conditions In an Sql Query

 
Chetan M
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How does sequence/order Of Conditions In an Sql Query matters 4 performance or execution time
 
Neeraj Kumar Mishra
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 9062
12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic