>> The index on session_date_created will ONLY help if it is by itself in >> the comparison such as >> >> DELETE FROM session_table WHERE (UNIX_TIMESTAMP(now()) - 8600) < >> session_date_created >> >> if there is any calculation done on session_date_created the index >> will not have any effect. > > Cool, I didn't know that. Thanks.
also too, if conversions are made between the data types indexes may not be used. -- ray _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
