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

[Ruslan Zasukhin]

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 )



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