While EAServer automatically creates entity bean tables for supported databases, this feature is provided as a development time convenience. For deployment to production servers, you or your DBA should create the tables, using an optimized index model and any other necessary optimizations, such as enabling row-level locking. You can also add tuning parameters to the SQL and DML syntax that is configured in the table mapping properties for the entity bean. For example, you might optimize the select query to force the use of an index by adding proprietary DBMS keywords.
For more information, see the description of the sql.createTables Ant property in Chapter 2, “Deploying and Configuring EJB Components,” in the Enterprise JavaBean User’s Guide.
