Re: What should be my PK?
What I meant is, currently my table is empty. I have not loaded my data yet.
Can I run EXPLAIN with empty table (or some data) and will EXPLAIN provide a realistic PLAN at this time?
Or I need to LOAD my entire data (~9 Billion), and then run EXPLAIN to get the PLAN?
**I was actually thinking the same way, NOT to index at this time, and once LOAD is complete, then index the fields.
Subject
Written By
Posted
Re: What should be my PK?
May 18, 2016 09:50AM
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.