User:Hibethy/sandbox

Limits
Information about data size limits.

Note (1): Firebird 2.x maximum database size is effectively unlimited with the largest known database size >980 GB. Firebird 1.5.x maximum database size: 32 TB.

Note (2): limit is 1038using  datatype

Note (3): InnoDB is limited to 8,000 bytes (excluding,  ,  , or   columns)

Note (4): InnoDB is limited to 1,000 columns

Note (6): Using  in SQL 2005 and later

Note (7): When using a page size of 32 kB, and when BLOB/CLOB data is stored in the database file.

Note (8): Java array size limit of 2,147,483,648 (231) objects per array applies. This limit applies to number of characters in names, rows per table, columns per table, and characters per /.

Note (9): Despite the lack of a date datatype, SQLite does include date and time functions, which work for timestamps between 0000-01-01 00:00:00 and 5352-11-01 10:52:47.

Note (10): Informix DATETIME type has adjustable range from YEAR only through 1/10000th second. DATETIME date range is 0001-01-01 00:00:00.00000 through 9999-12-31 23:59:59.99999.

Indexes
Information about what indexes (other than basic B-/B+ tree indexes) are supported natively.

Note (1): The users need to use a function from freeAdhocUDF library or similar.

Note (2): Can be implemented for most data types using expression-based indexes.

Note (3): Can be emulated by indexing a computed column (doesn't easily update) or by using an "Indexed View" (proper name not just any view works )

Note (4): Can be implemented by using an indexed view.

Note (5): InnoDB automatically generates adaptive hash index entries as needed.

Note (6): Can be implemented using Function-based Indexes in Oracle 8i and higher, but the function needs to be used in the sql for the index to be used.

Note (7): A PostgreSQL functional index can be used to reverse the order of a field.

<cite id="idx_8">Note (8): PostgreSQL will likely support on-disk bitmap indexes in a future version. Version 8.2 supports a related technique known as "in-memory bitmap scans".

<cite id="idx_10">Note (10): B+ tree and full-text only for now.

<cite id="idx_11">Note (11): R-Tree indexing available in base edition with Locator but some functionality requires Personal Edition or Enterprise Edition with Spatial option