Sorry a typo on point 5 ! and also left join instead of inner join

Hello,

1 - Is article.enabled indexed ?
2 - Is article.enabled switchable ? 0 to 1 or 1 to 0 ?
3 - If no (always 0 to 1), you could add in where clause " and
a.enabled=0"
4 - What is 104017 ? ARTICLE_CONTENTTREE_LINK.TREEID ?
5 - If yes, you could write
select 1 from ARTICLE_CONTENTTREE_LINK al
left JOIN SP_CT_VIDLIST_WITHROOT(al.treeid) s ON (1=1)
where al.treeid=104017

Regards

Alexandre

--- In firebird-support@yahoogroups.com, "amoradell" <amoradell@...>
wrote:

>
> Hello,
>
> 1 - Is article.enabled indexed ?
> 2 - Is article.enabled switchable ? 0 to 1 or 1 to 0 ?
> 3 - If no (always 0 to 1), you could add in where clause " and
> a.enabled=0"
> 4 - What is 104017 ? ARTICLE_CONTENTTREE_LINK.TREEID ?
> 5 - If yes, you could write
> select 1 from ARTICLE_CONTENTTREE_LINK al
> JOIN SP_CT_VIDLIST_WITHROOT(S.treeid) s ON (1=1)
> where s.treeid=104017
>
> Regards
>
> Alexandre
>
> --- In firebird-support@yahoogroups.com, "nilsboedeker"
> <nils.boedeker.support@> wrote:
> >
> > Hi
> >
> > i try:
> > > the In clause with Exists clause
> > >
> > > update article a set a.enabled=1
> > > where exists (select 1 from ARTICLE_CONTENTTREE_LINK al
> > > INNER JOIN SP_CT_VIDLIST_WITHROOT(104017) s ON
> > > (al.TREEID = s.RTREEID) where al.articleid=a.relid)
> > >
> > > regards
> > >
> > > Alexandre
> >
> > No Index used...
> >
> > Plan:
> > PLAN JOIN ((SP_CT_VIDLIST NATURAL)
> > PLAN (CONTENTTREE INDEX (RDB$PRIMARY2)), AL INDEX (RDB$PRIMARY52))
> > PLAN (A NATURAL)
> >
> > Adapted plan:
> > PLAN JOIN ((SP_CT_VIDLIST NATURAL)
> > PLAN (CONTENTTREE INDEX (PK_CONTENTTREE)), AL
> > INDEXPK_ARTICLE_CONTENTTREE_LINK52))
> > PLAN (A NATURAL)
> > 11 record(s) was(were) updated in ARTICLE
> >
> > any more ideas or do you need more information?
> >
> > with best regards
> >
> > Nils
> >
>