I have a table whose indexed column is a char(16) field. I am giving the schema.
CREATE TABLE Emp(Empno char(16),
Ename varchar(25),
Salary number(10,2),.. ....)
Now, there is an index on the Empno field. Now, inside a stored procedure, I am executing a statement
select Name=Ename from Emp where Empno=@eno
This @eno is varchar(25). So, SQL Server would do the implicit conversion between the char & varchar types in this query. Does this query use indexes?
If implicit conversion occurs between number & varchar2(in Oracle), indexes are naturally not used. But, how about the conversion between char & varchar?
Want some suggestions
CREATE TABLE Emp(Empno char(16),
Ename varchar(25),
Salary number(10,2),.. ....)
Now, there is an index on the Empno field. Now, inside a stored procedure, I am executing a statement
select Name=Ename from Emp where Empno=@eno
This @eno is varchar(25). So, SQL Server would do the implicit conversion between the char & varchar types in this query. Does this query use indexes?
If implicit conversion occurs between number & varchar2(in Oracle), indexes are naturally not used. But, how about the conversion between char & varchar?
Want some suggestions