faqts : Computers : Databases : MySQL : Language and Syntax : Performance

+ Search
 Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

1 of 2 people (50%) answered Yes
Recently 0 of 1 people (0%) answered Yes

Entry

Are indices used for numeric comparisons on string fields?

Feb 25th, 2000 16:56
Nathan Wallace, Michael Widenius
 


They aren't on 3.22 but are in 3.23.

You can easily check this with EXPLAIN.