The following limits apply to the c-tree ODBC Driver. Addition limits may be imposed by third-party ODBC applications.
Description |
Value |
---|---|
Concurrently open tables: 16-bit multi-user non-server driver All others |
305 405 |
Number of rows: |
2 billion |
Number of columns in a query: |
256 |
Size of a column: |
2 gigabytes |
Number of connections: |
limited by memory |
Table, index and column name length: |
64 characters |
Table qualifier: |
68 characters |
Maximum characters in a literal: |
1000 |
Maximum columns in a CREATE TABLE statement: |
256 |
Maximum ANDed predicates: This example uses three ANDed predicates: SELECT * FROM abc WHERE c1 AND c2 AND c3 AND c4 |
300 |
Number of joined tables: |
limited by memory |