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

    Large dataset and tuning Oracle DB

    jemous
      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)