Re: Java SQL interface


"lakshmi Ashok" wrote....

Who decides how long a query plan resides in the
DB cache in case of a SQL statement being fired
from the application.....???

If the DB even makes use of a query plan, in most cases it's the DB itself
that decides upon that.

// Bjorn A



Inviato da X-Privat.Org - Registrazione gratuita http://www.x-privat.org/join.php
.

Relevant Pages

  • Re: Prepared Statement
    ... A query plan is generated each time a query needs to be executed. ... The query plan is placed in the cache of the database for some time ... When your code opens a connection, and tries to execute the stmt, it ... A pointer to a result set will not exist if you close the connection ...
    (comp.lang.java.databases)
  • Re: Why running the same query after the first time is faster ?
    ... The other problem might be the query plan. ... You could clear the disk cache by doing a different query. ... >> Most likely it is cache, as Michael said. ...
    (microsoft.public.sqlserver.programming)
  • Re: Java SQL interface
    ... Thats interesting.... ... Who decides how long a query plan resides in the DB cache in case of a ... SQL statement being fired from the application.....??? ...
    (comp.lang.java.databases)
  • Re: Precompiled statement?
    ... I think my original question may have been unclear. ... What is actually being done when a SQL statement is being 'compiled'? ... Query plan? ... Parsing of SQL statement? ...
    (comp.lang.java.databases)