Java Doc for OptimizablePredicate.java in » Database-DBMS » db-derby-10.2 » org » apache » derby » iapi » sql » compile » 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.compile

Source Cross Reference

Class Diagram

Java Document (Java Doc)

org.apache.derby.iapi.sql.compile .OptimizablePredicate

All known Subclasses:   org.apache.derby.impl.sql.compile .Predicate,
OptimizablePredicate
public interface OptimizablePredicate (Code)
OptimizablePredicate provides services for optimizing predicates in a query.

Method Summary
boolean compareWithKnownConstant(Optimizable optTable, boolean considerParameters)

boolean equalsComparisonWithConstantExpression(Optimizable optTable)
     Is this predicate an equality comparison with a constant expression? (IS NULL is considered to be an = comparison with a constant expression).
DataValueDescriptor getCompareValue(Optimizable optTable)
     Get an Object representing the known constant value that the given Optimizable is being compared to.
int getIndexPosition()
     Get the position of the index column that this predicate restricts.
JBitSet getReferencedMap()
     Get the map of referenced tables for this OptimizablePredicate.
int hasEqualOnColumnList(int[] baseColumnPositions, Optimizable optTable)
     Returns if the predicate involves an equal operator on one of the columns specified in the baseColumnPositions.
Parameters:
  baseColumnPositions - the column numbers on which the user wantsto check if the equality condition exists.
Parameters:
  optTable - the table for which baseColumnPositions are given.
boolean hasMethodCall()
     Return whether or not an OptimizablePredicate contains a method call.
boolean hasSubquery()
     Return whether or not an OptimizablePredicate contains a subquery.
boolean isQualifier()

boolean isStartKey()

boolean isStopKey()

void markQualifier()
     Tell the predicate that it is to be used as a qualifier in an index scan.
void markStartKey()
     Tell the predicate that it is to be used as a column in the start key value for an index scan.
void markStopKey()
     Tell the predicate that it is to be used as a column in the stop key value for an index scan.
double selectivity(Optimizable optTable)
     Get a (crude) estimate of the selectivity of this predicate.

Method Detail
compareWithKnownConstant
boolean compareWithKnownConstant(Optimizable optTable, boolean considerParameters)(Code)
Is this predicate a comparison with a known constant value?
Parameters:
  optTable - The Optimizable that we want to know whether weare comparing to a known constant.
Parameters:
  considerParameters - Whether or not to consider parameters with defaultsas known constants.

equalsComparisonWithConstantExpression
boolean equalsComparisonWithConstantExpression(Optimizable optTable)(Code)
Is this predicate an equality comparison with a constant expression? (IS NULL is considered to be an = comparison with a constant expression).
Parameters:
  optTable - The Optimizable for which we want to know whetherit is being equality-compared to a constant expression.

getCompareValue
DataValueDescriptor getCompareValue(Optimizable optTable) throws StandardException(Code)
Get an Object representing the known constant value that the given Optimizable is being compared to.
exception:
  StandardException - Thrown on error

getIndexPosition
int getIndexPosition()(Code)
Get the position of the index column that this predicate restricts. NOTE: This assumes that this predicate is part of an OptimizablePredicateList, and that classify() has been called on the OptimizablePredicateList. The index position that this predicate restricts (zero-based)

getReferencedMap
JBitSet getReferencedMap()(Code)
Get the map of referenced tables for this OptimizablePredicate. JBitSet Referenced table map.

hasEqualOnColumnList
int hasEqualOnColumnList(int[] baseColumnPositions, Optimizable optTable) throws StandardException(Code)
Returns if the predicate involves an equal operator on one of the columns specified in the baseColumnPositions.
Parameters:
  baseColumnPositions - the column numbers on which the user wantsto check if the equality condition exists.
Parameters:
  optTable - the table for which baseColumnPositions are given. returns the index into baseColumnPositions of the column that has theequality operator.

hasMethodCall
boolean hasMethodCall()(Code)
Return whether or not an OptimizablePredicate contains a method call. boolean Whether or not an OptimizablePredicate includes a method call.

hasSubquery
boolean hasSubquery()(Code)
Return whether or not an OptimizablePredicate contains a subquery. boolean Whether or not an OptimizablePredicate includes a subquery.

isQualifier
boolean isQualifier()(Code)
Is this predicate a qualifier?

isStartKey
boolean isStartKey()(Code)
Is this predicate a start key?

isStopKey
boolean isStopKey()(Code)
Is this predicate a stop key?

markQualifier
void markQualifier()(Code)
Tell the predicate that it is to be used as a qualifier in an index scan.

markStartKey
void markStartKey()(Code)
Tell the predicate that it is to be used as a column in the start key value for an index scan.

markStopKey
void markStopKey()(Code)
Tell the predicate that it is to be used as a column in the stop key value for an index scan.

selectivity
double selectivity(Optimizable optTable) throws StandardException(Code)
Get a (crude) estimate of the selectivity of this predicate. This is to be used when no better technique is available for estimating the selectivity - this method's estimate is a hard- wired number based on the type of predicate and the datatype (the selectivity of boolean is always 50%).
Parameters:
  optTable - The Optimizable that this predicate restricts

www.java2java.com | Contact Us

All other trademarks are property of their respective owners.