com.aspc.job.internal

Class DBJobManagerSessionSearchPlan

java.lang.Object

com.aspc.DBObj.Internal.SearchPlan

com.aspc.DBObj.Internal.DBObjectSearchPlan

com.aspc.DBObj.Internal.impl.DBObjectSearchPlanV8

com.aspc.job.internal.DBJobManagerSessionSearchPlan

public class DBJobManagerSessionSearchPlan
extends DBObjectSearchPlanV8

Search plan optimize the query for DBjobManagerSession class that will detect when search is made on derived field status along with heartbeat THREAD MODE: SINGLE-THREADED query

Since:

3 October 2006

Author:

Varun Mishra

Field Summary

Fields inherited from class com.aspc.DBObj.Internal.DBObjectSearchPlan

MAX_JOINS, RESOLUTION_ARCHIVE_CACHE, RESOLUTION_DB_SEARCH, RESOLUTION_FIELD_CACHE, RESOLUTION_FIELD_CACHE_IN, RESOLUTION_FULL_SEARCH, RESOLUTION_LINKAGE_CACHE, RESOLUTION_LOAD_CACHE_IN, RESOLUTION_REVERSED, RESOLUTION_SPLIT_SEARCH

Fields inherited from class com.aspc.DBObj.Internal.SearchPlan

ALWAYS_LOAD_FIELD_CACHE_LIMIT, DEFAULT_TIMEOUT, maxFullListInsteadOfAffirmativeRestriction, maxFullRecordScan, query, RESOLUTION_KNOWN_TO_FAIL, RESOLUTION_UNKOWN

Constructor Summary

Constructors

Constructor and Description
DBJobManagerSessionSearchPlan(DBQuery query) Creates a new instance of DBJobSearchPlan

Method Summary

Modifier and Type	Method and Description
PossibleRowsHolder	tryPlanCache() Optimize the query when needed This was search plan was saying if you are searching for status = RUN then there must have been a heart beat in the last hour.

Methods inherited from class com.aspc.DBObj.Internal.impl.DBObjectSearchPlanV8

addSqlUsed, addTranslateMap, archiveSearch, createLayerPlan, doLayerSearch, doReverseSearch, getMatchEstimatePerRow, isUsingDefaultSearchPlan, listSqlUsed, makeLayerPlan, tryKeyWord, tryReverseSearch, trySplitOR, trySplitSearch, useClauseInsteadOfFullScan, useFullSearch, useLinkageCache

Methods inherited from class com.aspc.DBObj.Internal.SearchPlan

addClauseUsed, checkThirdPhase, checkTimeout, cleanCriteria, getBottomLayer, getCriteria, getDataBase, getEstimatedDatabaseRows, getEstimatedMatchRows, getEstimatedMatchRows, getFirstClausedUsed, getMaxFullListInsteadOfAffirmativeRestriction, getMaxFullRecordScan, getMaximumRequiredRows, getQuery, getResolution, getSecondClausedUsed, getStartTime, getThirdClausedUsed, getTopLayer, isLayerExcluded, setForcePhaseThree, setMasterPlan, setMaxFullListInsteadOfAffirmativeRestriction, setMaxFullRecordScan, setMaximumRequiredRows, setResolution, useCache, willSearchFail

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DBJobManagerSessionSearchPlan

public DBJobManagerSessionSearchPlan(DBQuery query)

Creates a new instance of DBJobSearchPlan

Parameters:

query - SQl

Method Detail

tryPlanCache

public PossibleRowsHolder tryPlanCache()
                                throws java.lang.Exception

Optimize the query when needed This was search plan was saying if you are searching for status = RUN then there must have been a heart beat in the last hour. There is no lost of timezones here.

Overrides:

tryPlanCache in class DBObjectSearchPlanV8

Returns:

The possible rows from the plan's special cache.

Throws:

java.lang.Exception - A serious problem