I have a subpartition table (millions) of data web service has to use this data and do some aggregation. It's taking a long time to retrieve. Are there any methods to improve the partition?
Daily Partitions With Hourly Subpartitions
Oracle 11.2, 64 bit Linux I have a number of tables I have partitioned daily and I retain data for 8 days, 32 days or 92 days, depending on the table. After the appropriate number of days, I drop...
Ten Million Row Database with Scalability Issues
I have been working with a SQL database and one of the tables has almost reached ten million rows. It’s time to start looking into sharding and partitioning options to allow the schema to grow...
Merge Loads With Million Data Load
I am having a problem in merge loads with million records load everyday in an oracle 11g database, though the data doesn't have issue was not loaded like that i got 52 records in 90 days. ...