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

    Large dataset and tuning Oracle DB

    Jemous-Oracle
      On this site you can download a large dataset:
      http://stat-computing.org/dataexpo/2009/
      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)