Tag Info

New answers tagged

1

If you could change the WHERE clause for the sake of the benchmark, do one of two things: OPTION #1 : Table Scan SET PROFILING=1; SELECT SQL_NO_CACHE field_a, field_b FROM table; SELECT SQL_NO_CACHE field_a, field_b FROM table; SELECT SQL_NO_CACHE field_a, field_b FROM table; SHOW PROFILES; OPTION #2 : Change WHERE xxx to WHERE 1=1 SET PROFILING=1; ...


0

... FROM tbl IGNORE INDEX (idx1, idx2, ...) ... Unfortunately, you need to know the names of all the indexes.



Top 50 recent answers are included