Efficient use of text-containing field

[Ruslan Zasukhin]

On 12/6/05 5:41 AM, "Ed Kleban" <Ed at Kleban.com> wrote:

> Since you're using IndexedByWord, as you say, then to also do a sort then
> yes, you'll need to allocate some other field.

Ed, with Valentina no need to make COPY of data.

You can just create calculated field, which will on the fly calculate value.
And then Jon say: build index for this calculated field.

So you get best case:

    one field which keep strings
    
    and 2 indexes around this field.


> And if you only need to do
> the sort on the first 16 characters, then creating a VarChar(16) field with
> a copy of the first 16 characters of the VarChar(1022) field will indeed
> save you a tremendous amount of storage and be much more space efficient
> than having to create two VarChar(1022) fields -- one to be IndexedByWords,
> and one to be Indexed for sorting.

-- 
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]