Until recently I thought limit on number of columns in Oracle DB was 255. But turns out the limit is 1000. Can someone confirm this?
Also I was trying to find if there is any similar limit on number of columns in Derby DB, particularly embedded derby java DB
Here's link to Oracle documentation: Logical Database Limits.
Excerpt:
Per table 1000 columns maximum
Per index (or clustered index) 32 columns maximum
Per bitmapped index 30 columns maximum
Here's link to Derby documentation: A Derby Database
Excerpt:
columns per table 1,012
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With