Title: Database Problems The design of

The database itself also limits its application. Listed below is the lower limit of a certain performance in each database. Database Name Length Oracle 8 Column Name Length Oracle 9 I 30 Index Name Oracle/Sybase 30 Table Name Oracle/Sybase 30 SQL variable DB 264 Max Char DB 2254 VarChar Oracle 4000 Maximum number of columns per table Oracle 1000 Stored procedure name length oracle 30max table row length SQL server 8036 Maximum number of columns per index ms sql server 16 Maximum SQL statement db 265535 Number of columns per select statement DB 1012 Number of columns per insert statement db2 1012