All Questions
3 questions
0
votes
1
answer
530
views
How to optimize Oracle create table function for a table having over 30 million rows and 250 columns
I need to create a table which has over 30 million rows and about 250 columns from another table which has same row number and about 230 columns. It is like ETL process. I use SPSS Modeler to run a ...
- 1
1
vote
0
answers
1k
views
Low performance on inserts with partitioned table in Oracle 12c
I have a partitioned table in oracle 12c with about 50 millions records. When i make a insert query against the db the response time is about 300 milliseconds, which is really slow compared to an ...
- 21
0
votes
1
answer
90
views
Best way to design for one-to-many code values in Oracle
We receive several millions of records per day on temperature metrics. Most of the pertinent metadata for these records is maintained in a single partitioned table by date (month). We are going to ...
- 7