test2order

\BEGIN{TABLE}
    \caption {test2order}
    \BEGIN{tabular}{|l|}
    \hline
    Test query BEFORE                                                                                                                                                                                                                                                                                        \\ \hline
    SELECT SQL\_NO\_CACHE * FROM persons\\  HAVING FirstName LIKE '\%а\%'\\    ORDER BY FirstName;                                                                                                                                                                                                            \\ \hline
    Client side timing: 0.0160\\Server side timing: 0.0159                                                                                                                                                                                                                                                   \\ \hline
    Test query after                                                                                                                                                                                                                                                                                         \\ \hline
    CREATE INDEX PersonsFirstNameIndex ON Persons(FirstName); \\\\SELECT SQL\_NO\_CACHE * FROM persons FORCE INDEX (PersonsFirstNameIndex)\\    HAVING FirstName LIKE '\%а\%'\\    ORDER BY FirstName;                                                                                                          \\ \hline
    Client side timing: 0.0\\Server side timing: 0.0018                                                                                                                                                                                                                                                      \\ \hline
    \END{tabular}
\END{TABLE}