Re: Partitioning
Posted by:
Rick James
Date: April 20, 2016 11:34PM
There is no advantage for PARTITION in the case you described.
It is not possible to have that many partitions. The actual limit is 8K; the _practical_ limit is about 50.
For your example data, you are expecting 3 rows for 'MC001', correct?
Is `id` supposed to be unique? Is some other column (or combination of columns) expected to be unique?
How big can URI be?
You are saying "lookup by a single URI" is the only only SELECT you will need to do? Then make a non-PARTITIONed table with the PRIMARY KEY _starting_ with uri. After you have answered the questions above, I can help you with the rest of the columns for the PRIMARY KEY.
The query will take on a few milliseconds 'always', even with 5 billion rows.
Subject
Written By
Posted
Re: Partitioning
April 20, 2016 11:34PM
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.