Categories
Databases English Performance Search algorithms

Build trees or depend on database indexes to enhance text search?

Should we create our own trees to make searches on strings faster, or we can depend on database engine non-clustered indexes on char or Varchar fields to do so? The following facts will help us in deciding and understanding what is really happening in indexed char columns: You can make an indexed column of Varchar2 […]