# Solution For Implicit Data Type Conversion

+ Optimized statement and execution plans:


![left](./student-guide/diagram/01-13-1.png)

------------------------------------------------------------
So how can this be solved? It's easy to find the reason, just use the correct type to query it:
(omitted)
The above case is also encountered when joining tables. If the two column type of the table join (large type, such as numeric and string are two large type, int and bigint are the same large type), join cannot be indexed.