Re: [Gmod-schema] identification of root term in cv

[Hilmar L. <hl...@gm...>]

some RDBMS may execute this faster if written as NOT EXISTS  
(depending on optimizer, it may choose to rewrite as an outer join  
that can use an index; NOT IN will typically use a full table scan).

sorry if this is confusing just ignore, the NOT IN will do fine in  
many cases ...

On Jul 20, 2006, at 1:28 PM, chris mungall wrote:

>
> Like this (from godb-bridge):
>
> SELECT * FROM cvterm WHERE cvterm_id NOT IN (SELECT DISTINCT
> subject_id FROM cvterm_relationship) AND is_obsolete = 0 AND
> is_relationshiptype = 0
>
> On Jul 20, 2006, at 1:39 AM, Kevin Manansala wrote:
>
>> Good day,
>>
>> I would like to know how to identify root cvterms of a cv in the
>> Chado schema?
>>
>> Thank you very much in advance.
>>
>> Cheers!
>>
>> -- 
>> Kevin L. Manansala
>> BS Computer Science
>> UP Diliman
>>
>> "I'm the best there is at what I do!" - wolverine
>> --------------------------------------------------------------------- 
>> -
>> ---
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to
>> share your
>> opinions on IT & business topics through brief surveys -- and earn
>> cash
>> http://www.techsay.com/default.php?
>> page=join.php&p=sourceforge&CID=DEVDEV_______________________________ 
>> _
>> _______________
>> Gmod-schema mailing list
>> Gmo...@li...
>> https://lists.sourceforge.net/lists/listinfo/gmod-schema
>
>
> ---------------------------------------------------------------------- 
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys -- and earn  
> cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Gmod-schema mailing list
> Gmo...@li...
> https://lists.sourceforge.net/lists/listinfo/gmod-schema
>

-- 
===========================================================
: Hilmar Lapp  -:-  Durham, NC  -:-  hlapp at gmx dot net :
===========================================================