SRCHSTAT

This table is used for capturing search related statistics at runtime.

Column Descriptions:

NameTypeDescription
SRCHSTAT_IDBIGINT NOT NULLInternal generated entry identifier
KEYWORDVARCHAR (254)Search keyword specified by shopper
LANGUAGE_IDINTEGER NOT NULLLanguage used for the session of the shopper
STOREENT_IDINTEGER NOT NULLThe store identifier
CATALOG_IDBIGINT NOT NULLCatalog used for the search operation
KEYWORDCOUNTBIGINT NOT NULLThe number of search operations for a keyword
SEARCHCOUNTBIGINT NOT NULLThe average number of search records returned upon a search operation
SUGGESTIONCOUNTBIGINTThe number of the keyword's first suggestion result
SUGGESTIONVARCHAR (254)List of keyword suggestions upon a search miss
LOGDETAILVARCHAR (2048)List of synonyms of a search term.
LOGDATETIMESTAMP NOT NULLDate and time where this entry is logged
OBJECTTYPEVARCHAR (64)IBM internal use
OBJECT_IDVARCHAR (64)IBM internal use
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>SRCHSTAT_IDPrimary Key
I0001391 KEYWORD+LANGUAGE_ID+STOREENT_ID+KEYWORDCOUNT+LOGDATE+SEARCHCOUNT+SUGGESTIONNon-Unique Index
I0001392STOREENT_ID+LOGDATENon-Unique Index