skip to main content
Reference : Designing JDBC Applications for Performance Optimization : Using Database Metadata Methods
  

Using Database Metadata Methods

Because database metadata methods that generate ResultSet objects are slow compared to other JDBC methods, their frequent use can impair system performance. The guidelines in this section will help you optimize system performance when selecting and using database metadata.
In this section: 
* Minimizing the Use of Database Metadata Methods
* Avoiding Search Patterns
* Using a Dummy Query to Determine Table Characteristics