Re: r480 - trunk/db

["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