Loading...
   
      
 
                    Select Version
                  
                   
                
                          Maximum size of an unpartitioned base table  |  
   4 TB  |  
  
Maximum size of a partition  |  
   4 TB  |  
  
Maximum size of a partitioned base table  |  
   64 TB  |  
  
Number of partitions in a table  |  
   16  |  
  
Number of records in a partition of a partitioned table  |  
   268,435,454  |  
  
Number of records in a partitioned table  |  
   4,294,967,264  |  
  
Number of records in a non-partitioned table  |  
   4,294,967,294  |  
  
Number of columns in a table with data type not equal to   |  
   26,134  |  
  
Number of columns in a table with data type (N)VARCHAR  |  
   1,000  |  
  
Maximum dimension of a multiple column  |  
   255  |  
  
Number of tables or partitions per space  |  
   30,000  |  
  
Number of indexes per space  |  
   32,767  |  
  
Table 78: Maximum sizes for base tables