Warning 1013103

"JI MATCH E=%1;S=%2;TID=%3;NRows=%4;JID=%5;NTab=%6;Miss=%7;Data=%8"

Item Description

SQLCode

1013103L

Constant

EMSG_SQL_JOIN_MATCH_SCORE

SQLState

QCB03

ODBC 2 State

OK

ODBC 3 State

OK

Sybase Error Code

21026

Severity Code

1

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 nomatch

Parameter 8

A Flag specifying if the join has data

Probable cause

During a SELECT the Join Indexs 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.


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com