JI MATCH E=%1;S=%2;TID=%3;NRows=%4;JID=%5;NTab=%6;Miss=%7;Data=%8
Item |
Value |
|---|---|
SQLCode |
-1013103 |
Constant |
EMSG_SQL_JOIN_MATCH_SCORE |
SQLState |
QCB03 |
ODBC State |
OK |
Parameter 1 |
the ID of the match (an index into the array of scores) |
Parameter 2 |
the Join Match Score (how well it matched) |
Parameter 3 |
the Table ID used to find a match |
Parameter 4 |
the number of rows in the table |
Parameter 5 |
the Join Index ID being tested for a match |
Parameter 6 |
the number of tables that matched the join |
Parameter 7 |
the number of tables that missed, zero for exact and minus one for no match |
Parameter 8 |
a flag specifying if the join has data |
During a SELECT the JOIN INDEXes are searched for a good match to increase the speed of the query. THis message relays the scoring given to each table/join index matched.
