SQL Query

JDBC V1

• JDBC Java DataBase Connectivity. This is an application programming interface (API) for the Java programming language, which defines how a client may access a database. V1 is similar in its performance and its coverage to the GigaSpaces API and is used only in our XAP GigaSpaces eXtreme Application Platform. Provides a powerful solution for data processing, launching, and running digital services solution.

• The Explain Plan This is a quick, simple lightweight SQL tool that shows you a compiled plan in tabular form without executing it. It is a tool or function provided by the DBMS (Database Management System) that makes an execution plan visible. This will show index usage and how the scans of the exuction will appear. analysis tool can be used for debugging.

JDBC V3

• JDBC V3 has SQL 99 coverage, however it is more complex but the performance of simple queries will be slightly less than JDBC V1.

• In addition, JDBC V3 has support for ODBC Microsoft Open DataBase Connectivity. This interface is a C programming language interface that makes it possible for applications to access data from a variety of database management systems (DBMSs). ODBC is a low-level, high-performance interface that is designed specifically for relational data stores. and JDBC Postgress flavors.

• Analysis tools such as Explain Plan and PostgreSQL Explain Analyze can be used for debugging.

• For additional information see the Integrating with BI Tools section.