A full table scan was performed on the rwt_screens table. The /* ... */ means that if the dbms is 4.0.x then do not cache this query.
-----Original Message----- From: Luis Lebron [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 8:52 AM To: Mysql (E-mail) Subject: Question on slow queries I just started logging slow queries. Today I found the following lines in the slow query log. # Query_time: 14 Lock_time: 0 Rows_sent: 293 Rows_examined: 293 use storyboards; SELECT /*!40001 SQL_NO_CACHE */ * FROM `rwt_screens`; What exact does the third line mean? thanks, Luis R. Lebron Sigmatech, Inc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]