Been playing around with the QryLog logging type and was wondering if someone could help me get my head around what it is telling me. Some of it is self-explanatory, and I can make assumptions about other stuff, but I'd rather not assume! Here's the output for on of the queries I'm interested in:
Code:
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Query Plan: CreateQuery Farselwt.w line 11006
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO QueryId: 35052280
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Query Handle: 1811
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Type: Dynamically Opened Query
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO PREPARE-STRING: FOR EACH FaultReport NO-LOCK WHERE ICMAS.FaultReport.FarDeveloperPersonKey = 49775421 AND LOOKUP(STRING(ICMAS.FaultReport.ObjectStatusKey,'999999999'),'003540805,029753236,090400997,029753234,090400998,029753238,029753235,029753239,029753240,063726893') GT 0 AND LOOKUP(STRING(ICMAS.FaultReport.FarBusinessJustification),'BUSRISK,CUSCRIT,FINANCE,NONE,OPPORT,RESOURCE') GT 0 AND ICMAS.FaultReport.FarManagerConfirmedDate= ICMAS.FaultReport.FarManagerConfirmedDate,FIRST FaultReportCategory WHER
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Prepared at Runtime
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Client Sort: Y
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Scrolling: Y
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Table: icmasliv.FaultReport
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Indexes: DeveloperIdx
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Table: icmasliv.FaultReportCategory
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Indexes: FaultReportCategoryKeyIdx
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Table: icmasliv.Person
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Indexes: PersonPkey
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Table: icmasliv.lb-Person
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Indexes: PersonPkey
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Table: icmasliv.ObjectStatus
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Indexes: ObjectStatusPkey
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Table: icmasliv.TeamMember
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Indexes: PersonKeyIdx
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Table: icmasliv.Team
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Indexes: TeamPkey
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Table: icmasliv.EntityFieldChoiceValues
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Indexes: IdxFieldChoiceKey
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Table: icmasliv.Customer
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Indexes: CustomerPkey
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Table: icmasliv.Supplier
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO Indexes: SupplierPkey
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Query Statistics: CreateQuery Farselwt.w line -1
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO QueryId: 35052280
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Query Handle: 1811
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Times prepared: 1
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Time to prepare (ms): 11
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO DB Blocks accessed to prepare:
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO icmasliv : 82
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Times opened: 1
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Entries in result list: 17
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Time to build result list (ms): 65
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO DB Blocks accessed to build result list:
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO icmasliv : 1301
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO DB Reads to build result list:
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Table: icmasliv.FaultReport : 267
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Index: FaultReport.DeveloperIdx : UNAVAILABLE
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Table: icmasliv.FaultReportCategory : 17
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Index: FaultReportCategory.FaultReportCategoryKeyIdx : UNAVAILABLE
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Table: icmasliv.Person : 45
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Index: Person.PersonPkey : UNAVAILABLE
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Table: icmasliv.lb-Person : 45
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Index: lb-Person.PersonPkey : UNAVAILABLE
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Table: icmasliv.ObjectStatus : 204
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Index: ObjectStatus.ObjectStatusPkey : UNAVAILABLE
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Table: icmasliv.TeamMember : 22
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Index: TeamMember.PersonKeyIdx : UNAVAILABLE
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Table: icmasliv.Team : 17
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Index: Team.TeamPkey : UNAVAILABLE
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Table: icmasliv.EntityFieldChoiceValues : 62
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Index: EntityFieldChoiceValues.IdxFieldChoiceKey : UNAVAILABLE
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Table: icmasliv.Customer : 28
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Index: Customer.CustomerPkey : UNAVAILABLE
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Table: icmasliv.Supplier : 1
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO Index: Supplier.SupplierPkey : UNAVAILABLE