Java Doc for RunTimeStatistics.java in » Database-DBMS » db-derby-10.2 » org » apache » derby » iapi » sql » execute » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation

1.	6.0 JDK Core
2.	6.0 JDK Modules
3.	6.0 JDK Modules com.sun
4.	6.0 JDK Modules com.sun.java
5.	6.0 JDK Modules sun
6.	6.0 JDK Platform
7.	Ajax
8.	Apache Harmony Java SE
9.	Aspect oriented
10.	Authentication Authorization
11.	Blogger System
12.	Build
13.	Byte Code
14.	Cache
15.	Chart
16.	Chat
17.	Code Analyzer
18.	Collaboration
19.	Content Management System
20.	Database Client
21.	Database DBMS
22.	Database JDBC Connection Pool
23.	Database ORM
24.	Development
25.	EJB Server geronimo
26.	EJB Server GlassFish
27.	EJB Server JBoss 4.2.1
28.	EJB Server resin 3.1.5
29.	ERP CRM Financial
30.	ESB
31.	Forum
32.	GIS
33.	Graphic Library
34.	Groupware
35.	HTML Parser
36.	IDE
37.	IDE Eclipse
38.	IDE Netbeans
39.	Installer
40.	Internationalization Localization
41.	Inversion of Control
42.	Issue Tracking
43.	J2EE
44.	JBoss
45.	JMS
46.	JMX
47.	Library
48.	Mail Clients
49.	Net
50.	Parser
51.	PDF
52.	Portal
53.	Profiler
54.	Project Management
55.	Report
56.	RSS RDF
57.	Rule Engine
58.	Science
59.	Scripting
60.	Search Engine
61.	Security
62.	Sevlet Container
63.	Source Control
64.	Swing Library
65.	Template Engine
66.	Test Coverage
67.	Testing
68.	UML
69.	Web Crawler
70.	Web Framework
71.	Web Mail
72.	Web Server
73.	Web Services
74.	Web Services apache cxf 2.0.1
75.	Web Services AXIS2
76.	Wiki Engine
77.	Workflow Engines
78.	XML
79.	XML UI

Java

Java Tutorial

Illustrator Tutorials

GIMP Tutorials

C# / C Sharp

C# / CSharp Tutorial

C# / CSharp Open Source

SQL Server / T-SQL Tutorial

Oracle PL / SQL

Oracle PL/SQL Tutorial

Flash / Flex / ActionScript

VBA / Excel / Access / Word

XML

XML Tutorial

Microsoft Office PowerPoint 2007 Tutorial

Microsoft Office Excel 2007 Tutorial

Microsoft Office Word 2007 Tutorial

Java Source Code / Java Documentation » Database DBMS » db derby 10.2 » org.apache.derby.iapi.sql.execute

Source Cross Reference

Class Diagram

Java Document (Java Doc)

org.apache.derby.iapi.sql.execute .RunTimeStatistics

All known Subclasses:   org.apache.derby.impl.sql.execute.rts .RunTimeStatisticsImpl,
RunTimeStatistics
public interface RunTimeStatistics (Code)
A RunTimeStatistics object is a representation of the query execution plan and run time statistics for a java.sql.ResultSet. A query execution plan is a tree of execution nodes. There are a number of possible node types. Statistics are accumulated during execution at each node. The types of statistics include the amount of time spent in specific operations (if STATISTICS TIMING is SET ON), the number of rows passed to the node by its child(ren) and the number of rows returned by the node to its parent. (The exact statistics are specific to each node type.)
RunTimeStatistics is most meaningful for DML statements (SELECT, INSERT, DELETE and UPDATE).

Method Summary
public Timestamp getBeginCompilationTimestamp()
     Get the timestamp for the beginning of query compilation.
public Timestamp getBeginExecutionTimestamp()
     Get the timestamp for the beginning of query execution.
public long getBindTimeInMillis()
     Get the bind time for the associated query in milliseconds.
public long getCompileTimeInMillis()
     Get the total compile time for the associated query in milliseconds.
public Timestamp getEndCompilationTimestamp()
     Get the timestamp for the end of query compilation.
public Timestamp getEndExecutionTimestamp()
     Get the timestamp for the end of query execution.
public double getEstimatedRowCount()
     Get the estimated row count for the number of rows returned by the associated query or statement.
public long getExecuteTimeInMillis()
     Get the execute time for the associated query in milliseconds.
public long getGenerateTimeInMillis()
     Get the generate time for the associated query in milliseconds.
public long getOptimizeTimeInMillis()
     Get the optimize time for the associated query in milliseconds.
public long getParseTimeInMillis()
     Get the parse time for the associated query in milliseconds.
public String getSPSName()
     Get the name of the Stored Prepared Statement used for the statement.
public String getScanStatisticsText()
     Get a String representation of the information on the nodes relating to table and index scans from the execution plan for the associated query or statement.
public String getScanStatisticsText(String tableName)
     Get a String representation of the information on the nodes relating to table and index scans from the execution plan for the associated query or statement for a particular table.
public String getStatementExecutionPlanText()
     Get a String representation of the execution plan for the associated query or statement.
public String getStatementName()
     Get the name of the associated query or statement.
public String getStatementText()
     Get the text for the associated query or statement.

Method Detail
getBeginCompilationTimestamp
public Timestamp getBeginCompilationTimestamp()(Code)
Get the timestamp for the beginning of query compilation.
A null is returned if STATISTICS TIMING is not SET ON. The timestamp for the beginning of query compilation.

getBeginExecutionTimestamp
public Timestamp getBeginExecutionTimestamp()(Code)
Get the timestamp for the beginning of query execution.
A null is returned if STATISTICS TIMING is not SET ON. The timestamp for the beginning of query execution.

getBindTimeInMillis
public long getBindTimeInMillis()(Code)
Get the bind time for the associated query in milliseconds. The bind time for the associated query in milliseconds.

getCompileTimeInMillis
public long getCompileTimeInMillis()(Code)
Get the total compile time for the associated query in milliseconds. Compile time can be divided into parse, bind, optimize and generate times.
0 is returned if STATISTICS TIMING is not SET ON. The total compile time for the associated query in milliseconds.

getEndCompilationTimestamp
public Timestamp getEndCompilationTimestamp()(Code)
Get the timestamp for the end of query compilation.
A null is returned if STATISTICS TIMING is not SET ON. The timestamp for the end of query compilation.

getEndExecutionTimestamp
public Timestamp getEndExecutionTimestamp()(Code)
Get the timestamp for the end of query execution.
A null is returned if STATISTICS TIMING is not SET ON. The timestamp for the end of query execution.

getEstimatedRowCount
public double getEstimatedRowCount()(Code)
Get the estimated row count for the number of rows returned by the associated query or statement. The estimated number of rows returned by the associatedquery or statement.

getExecuteTimeInMillis
public long getExecuteTimeInMillis()(Code)
Get the execute time for the associated query in milliseconds.
0 is returned if STATISTICS TIMING is not SET ON. The execute time for the associated query in milliseconds.

getGenerateTimeInMillis
public long getGenerateTimeInMillis()(Code)
Get the generate time for the associated query in milliseconds.
0 is returned if STATISTICS TIMING is not SET ON. The generate time for the associated query in milliseconds.

getOptimizeTimeInMillis
public long getOptimizeTimeInMillis()(Code)
Get the optimize time for the associated query in milliseconds.
0 is returned if STATISTICS TIMING is not SET ON. The optimize time for the associated query in milliseconds.

getParseTimeInMillis
public long getParseTimeInMillis()(Code)
Get the parse time for the associated query in milliseconds.
0 is returned if STATISTICS TIMING is not SET ON. The parse time for the associated query in milliseconds.

getSPSName
public String getSPSName()(Code)
Get the name of the Stored Prepared Statement used for the statement. This method returns a value only for EXECUTE STATEMENT statements; otherwise, returns null.
Note that the name is returned in the schema.name format (e.g. APP.MYSTMT). The Stored Prepared Statement name of the associated statement, or null if it is not an EXECUTE STATEMENT statement.

getScanStatisticsText
public String getScanStatisticsText()(Code)
Get a String representation of the information on the nodes relating to table and index scans from the execution plan for the associated query or statement. The nodes relating to table and index scansfrom the execution plan for the associated query or statement.

getScanStatisticsText
public String getScanStatisticsText(String tableName)(Code)
Get a String representation of the information on the nodes relating to table and index scans from the execution plan for the associated query or statement for a particular table.

Parameters:
  tableName - The table for which user desires statistics.
The nodes relating to table and index scansfrom the execution plan for the associated query or statement.

getStatementExecutionPlanText
public String getStatementExecutionPlanText()(Code)
Get a String representation of the execution plan for the associated query or statement. The execution plan for the associated query or statement.

getStatementName
public String getStatementName()(Code)
Get the name of the associated query or statement. (This will be an internally generated name if the user did not assign a name.) The name of the associated query or statement.

getStatementText
public String getStatementText()(Code)
Get the text for the associated query or statement. The text for the associated query or statement.

www.java2java.com | Contact Us

All other trademarks are property of their respective owners.