[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
Re: r480 - trunk/db
- To: uu@total-knowledge.com
- Subject: Re: r480 - trunk/db
- From: Alexey Parshin <alexeyp@gmail.com>
- Date: Wed, 24 Jun 2009 14:21:34 +1000
- Delivered-to: mailing list uu@total-knowledge.com
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=UbBXeEsNkqhK/2DpQLWOSSdGh/y3E27VU6/CYI1AQEE=; b=Xtp4b7QNDCGIqZJHXr79HZaVA9236vltCBjApD5tdKnb8TberquM90JzvevM2WZKql GRwXCsYc0a7JhFRIFFNWr6WVHk+8dEkAhI4OB+UWaTWsnKJsOi+IWBLhEodlazrI5b+Z FGtSa6jhUqHJmCNfx3f5aJvL7xiJghC8tOj5g=
- Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=rMjfV/ZblWlI9Y3fsaPTo4duaT423aWSJCqX+6+IJVamsllUjo0mWuHwfxnl3gn/wg WfHJn7XSl/xRJpjlIwTtrqtJRI8+wRBUiu3rH1NUq0j/fOYFchHBZ6sNf9YNWzE8b3la jlPMIukDmkF78+jNzMdjDVsRQ8o/nrJco83Cs=
- In-reply-to: <4A41A714.7070704@total-knowledge.com>
- Mailing-list: contact uu-help@total-knowledge.com; run by ezmlm
- References: <courier.000000004A3FF43E.000053E5@mail.total-knowledge.com> <a75bc3cf0906231517n6b22cf48ra05ab8fa23f43764@mail.gmail.com> <4A41A714.7070704@total-knowledge.com>
Hmm. Ok
2009/6/24 Ilya A. Volynets-Evenbakh <ilya@total-knowledge.com>
> And how is this wrong?
> (mind you - there is no uctu_umo_version now)
>
>
> Alexey Parshin wrote:
> > Actually, this is partially wrong.
> >
> > This creates an index that is accelerating certain types of queries:
> >
> > create unique index uix_uctu_umo_category_umo_version ON
> > umo_category_to_umo(uctu_umo_category,uctu_umo_version);
> >
> >
> > 2009/6/23 <ilya@mail.total-knowledge.com>
> >
> >
> >> Author: ilya
> >> Date: 2009-06-22 14:14:38 -0700 (Mon, 22 Jun 2009)
> >> New Revision: 480
> >>
> >> Modified:
> >> trunk/db/extra_indices.sql
> >> Log:
> >> Update umo-category intermediate table index
> >>
> >> Modified: trunk/db/extra_indices.sql
> >> ===================================================================
> >> --- trunk/db/extra_indices.sql 2009-06-22 19:06:02 UTC (rev 479)
> >> +++ trunk/db/extra_indices.sql 2009-06-22 21:14:38 UTC (rev 480)
> >> @@ -14,7 +14,7 @@
> >> create unique index ixu_scsr_title ON
> >> study_course_subscription_rule(scsr_title);
> >>
> >> create unique index uix_ucl_name ON umo_category_list(ucl_name);
> >> -create unique index uix_uctu_umo_category_umo_version ON
> >> umo_category_to_umo(uctu_umo_category,uctu_umo_version);
> >> +create unique index uix_uctu_umo_category_umo_base ON
> >> umo_category_to_umo(uctu_umo_category,uctu_umo_base);
> >>
> >> -- Accelerating ACL reads
> >> create unique index ixu_acl_object_type_id_group on
> >> access_control_list(acl_object_type,acl_object_id,acl_group);
> >>
> >>
> >>
> >
> >
> >
>
>
> --
> Ilya A. Volynets-Evenbakh
> http://www.total-knowledge.com
>
>
--
Alexey Parshin,
http://www.sptk.net