Thanks for your reply.
But is there any rule that if there is a mismatch in length or different types like(VarChar and Char), the index won't be used ???
Have a question regarding index usage
Example of the scenario :
Table A
Column AA Varchar(15) ----> indexed
Column AB decimal(15,2)
Table B
Column BA Char(5)----> indexed
Column BB Decimal (10,2)----> indexed
Will the following join use the index ?
where condition : Column...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.