var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Tell me something about Indexes
Tell Me something about Indexes .
There is Table Name Emp
and there is Index on Ename
Tell me in which case index will be used
1 Select ename from emp where ename = 'abc'
2. Select ename from emp where ename like 'abc%'
Please help me .
Re: Tell me something about Indexes
the index can be used in both cases.
If you are using the RuleBasedOptimizer then the index will be used in both cases.
If you are using the CostBasedOptimizer then the use of an index depends on several statistics (number of rows in the table, selectivity of the column, etc.).