[
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 <sparx@total-knowledge.com>
- Date: Wed, 24 Jun 2009 08:17:09 +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:sender:received:in-reply-to :references:date:x-google-sender-auth:message-id:subject:from:to :content-type; bh=Hoi/BEZ/Ll68q4IZsLl4irbH84uXi2Qhp6x0piEMqzw=; b=VfKoXl4w/zgTrKVhQQ2cZRj7WCyJhQzUWzb9+ADb+u05tC+1chuJ0tAHq1OFtshfbV OayACrAd1nigfiz1RSPqumeUbk0YofQgKPHypLJy3Lo52FUkXSsrsosrymAE0dFFpR8K IDowgAjIikQs+G6LYZEWkXYddxFMcv5m07uqo=
- Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:in-reply-to:references:date :x-google-sender-auth:message-id:subject:from:to:content-type; b=FvJPecVJAQaCm1zLZmmzG6qmdycSTYmgNr2E+Dmdvq2vpnDUL4RiD7kUDXgWOu9MLS 6qt/xtd5N5bSYt+L+yQE4msbQ+sMhEqpx4SScffGXeN73HLsAngJUtv0cs0zw8KSl52F Tc00gPgR2/7SR4Hv1eBCtsbfds2caiHJW1in4=
- In-reply-to: <courier.000000004A3FF43E.000053E5@mail.total-knowledge.com>
- Mailing-list: contact uu-help@total-knowledge.com; run by ezmlm
- References: <courier.000000004A3FF43E.000053E5@mail.total-knowledge.com>
- Sender: alexeyp@gmail.com
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);
>
>
--
Alexey Parshin,
http://www.sptk.net