2488835 - Index Advisor shows mismatch datatype for varchar columns join (Hash) where datatype is not the same as declared in create table statement. | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2488835 - Index Advisor shows mismatch datatype for varchar columns join (Hash) where datatype is not the same as declared in create table statement.

Symptom

  • Index Advisor Join Key Columns IEM.customer.domicile_country_code (varchar(2)) and IEM.country.code (varchar(9)) have mismatched data types 
    
    From query plan: Output 6 FPVALUE(FPORDINAL(customer_2__.domicile_country_code`(2), 1)) Output 6 Data Type varchar(2) Output 6 Column's Declared Data Type varchar(60) and Output 1 country_2__.code`(66) Output 1 Data Type varchar(9) Output 1 Column's Declared Data Type varchar(254) CREATE TABLE statement for table IEM.customer: ....... derivative_client_type_code varchar(60) null, derivative_client_type_desc varchar(60) null, derived_obligor_limit_rating varchar(60) null, domicile_city_bkp varchar(60) null, domicile_country_code varchar(60) null, <============= domicile_postal_code varchar(60) null, domicile_state_or_province varchar(60) null, domicile_street_address varchar(254) null, .......
  • Inner and outer joins performance may be affected

Read more...

Environment

  • IQ16.0 and later

Product

SAP IQ 16.0

Keywords

IQ mismatched data types advisor , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.