View RSS Feed

JDBC

Java Database Connectivity (JDBC) examples. SQL with Java.

  1. How does a database execute a statement?

    by , 04-27-2012 at 07:09 PM
    Obviously, don't expect alot of detail here; we'll only examine the aspects important to this article. When a database receives a statement, the database engine first parses the statement and looks for syntax errors. Once the statement is parsed, the database needs to figure out the most efficient way to execute the statement. This can be computationally quite expensive. The database checks what indexes, if any, can help, or whether it should do a full read of all rows in a table. Databases use ...