: Larry Brown [mailto:[EMAIL PROTECTED]
Sent: Monday, January 26, 2004 10:27 AM
To: Paul DuBois; MySQL List
Subject: RE: order of elements in where clause
ok, I have a table with 100,000+ records. 98% of these records are jobs that
have been completed. I have created an index for status. Status=4 is
re, but isn't this saying that the
index is not being used?
Larry
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 24, 2004 8:14 PM
To: Larry Brown; MySQL List
Subject: Re: order of elements in where clause
At 8:34 -0500 1/24/04, Larry Brown wrote:
At 8:34 -0500 1/24/04, Larry Brown wrote:
in a select statement, is the order of elements in the where clause the
determining factor on what records are chosen first, second etc?
No. The optimizer examines the query to determine the most efficient
way to execute the query. You can get information
