Inconsistent behavior between VString and VText for Indexed by Word search

[Ruslan Zasukhin]

On 8/16/11 8:47 PM, "Ernesto Giannotta" <erne at apimac.com> wrote:

>>> A last question, how can an index be used in a "contains" search such as
>>> '%something%' LIKE?
>>> 
>>> 
>> It's too internal things :) but it is so. Looks similar to index scanning.
>> 
> 
> Ever amazing Vale keeps her secrets well! :-)

Actually such indexed scan is normal thing for page-based DBs like mySQL,
Postgre, MS SQL, ...

Because they have BIG table, e.g. 2GB, and index can be much less.


But Valentina keep fields as columns, so COLUMN SCAN can be more effective
of INDEX SCAN, because index is bigger of column itself.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]