[ALL] Second project... SOLVED -- how to use EXPLAIN !

[Ruslan Zasukhin]

On 7/15/06 1:36 PM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

> On 7/15/06 1:25 PM, "Stan Busk" <maxprog at mac.com> wrote:
> 
>>> In V2 we have deprecate this behavior. Developer SELF must specify,
>>> which fields are indexed, and DB ENGINE do not change structure of db.
>> 
>> Yes but all fields use in queries are indexed:
> 
>>    mNewsgroups   = new VvarChar  ( "Article_Newsgroups",  1022,
>> EVFlag.fIndexByWords )            // Article Newsgroups Header
> 
> If you look by Valentina Studio into your db you will see that field
> 
> 
>     Article_Newsgroups              W
> 
> Has flag "W" but it do not have flag "I"
> 
> 
> You need do 
> 
> 
>     mNewsgroups = new VvarChar( "Article_Newsgroups",  1022,
>        EVFlag.fIndexByWords + EVFlag.fIndexed )

Please read this WIKI page:

http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:documen
tation:vkernel:vfield:flags


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