1 Reply Latest reply on Jun 26, 2012 5:40 AM by Sherry Lamonica-Oracle

    Large dataset and tuning Oracle DB

      On this site you can download a large dataset:
      Containing approximately 120 million records.
      I did a test on my laptop ~ 11 mio records in an uncompressed and a compressed table and this allready delivered impressive result.
      Size 1424 MB --> 375 MB
      Perf: 165 sec --> 51 sec
      ore.crosstab(~Year, data=ONTIME_L_COMP)