1 Reply Latest reply: Sep 3, 2012 6:14 AM by kuljeet singh - RSS

    BLOBS PERFORMANCE

    khurram82
      I have billions of JPEG data (approx 50K each jpeg size ) which is required to load in the oracle database date wise.

      , I need some suggestions whether I should keep one partitional based table for whole data or I should make separate
      table for each date . what will be impact of the both sceniro performance wise .


      Regards
        • 1. Re: BLOBS PERFORMANCE
          kuljeet singh -
          , I need some suggestions whether I should keep one partitional based table for whole data or I should make separate table for each date
          First point here is license as partition required license to use it.
          if you've license to use it then go for partition as we can partition tables that contain LOB columns. As a result, LOBs can take advantage of all of the benefits of partitioning
          http://docs.oracle.com/cd/B19306_01/appdev.102/b14249/adlob_tables.htm#i1014212