UniverseUniversity


Home Projects Jobs Clientele Contact

uu


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: r480 - trunk/db



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

Authoright © Total Knowledge: 2001-2008