List:General Discussion« Previous MessageNext Message »
From:Erv Young Date:June 11 2002 12:58am
Subject:MySQL AB: Need documentation clarification
View as plain text  
MySQL AB staff:

1)  The recent discussion on the subject "Not using indexes???" brought to 
light an opportunity for interpreting the documentation in contradictory 
ways.  The page http://www.mysql.com/doc/M/y/MySQL_indexes.html does not 
mention the IS NOT NULL comparison operator, nor does it mention the 
inequality (<>) operator.

This allows the reader to believe that since those operators are not 
mentioned, it goes without saying that they never use an index.  It also 
allows the reader to believe that since each is simply the negation of a 
comparison whose index use is specifically documented, it goes without 
saying that they also use an index.

Which of these interpretations is the truth that goes without saying, and 
which is the error that should be obvious even to the uninitiated?  Or 
(removing my tongue gingerly from my cheek), what is going on here?

2)  Also, the discussion of ANALYZE TABLE at 
http://www.mysql.com/doc/A/N/ANALYZE_TABLE.html leaves the user of InnoDB 
tables in limbo.  If this doesn't work on InnoDB tables, what takes its 
place, or why does its place not need to be taken?

Thanks.

--Erv Young

Thread
MySQL AB: Need documentation clarificationErv Young11 Jun
  • Re: MySQL AB: Need documentation clarificationDan Nelson11 Jun
    • RE: MySQL AB: Need documentation clarificationJon Frisby11 Jun
Re: MySQL AB: Need documentation clarificationHeikki Tuuri11 Jun
Re: MySQL AB: Need documentation clarificationHeikki Tuuri11 Jun
Re: MySQL AB: Need documentation clarificationJeff Kilbride12 Jun
  • Re: MySQL AB: Need documentation clarificationJeremy Zawodny1 Jul