Re: Modify primary key for partitioning
>Update query would use Primary key, so why would you create index on RECEIVED_DATE or ('REVCEIVED_DATE','ID_MSG')?
Because I was wondering of creating the PK in the opposite way ('REVCEIVED_DATE','ID_MSG') so that a query with only the column ID_MSG in the where clause wouldn't use the PK.
Subject
Views
Written By
Posted
3260
August 10, 2012 10:29AM
1835
August 18, 2012 09:39PM
2111
August 20, 2012 06:33AM
1866
August 22, 2012 10:16AM
1953
August 23, 2012 09:16AM
1849
August 23, 2012 10:42AM
1837
August 28, 2012 10:14AM
1858
August 30, 2012 10:26PM
2294
August 31, 2012 03:05AM
1873
August 31, 2012 03:38AM
Re: Modify primary key for partitioning
1778
August 31, 2012 06:48AM
1875
August 31, 2012 09:39AM
1762
September 04, 2012 01:02AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.