While EAServer automatically creates entity bean tables for most 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 “Configuring table-mapping properties” in Chapter 27, “Creating Entity Components,” in the EAServer Programmer’s Guide.
