Subscribing is a smart move!
You can subscribe to this forum after you log in or create your free account.
Geo SCADA Knowledge Base
Access vast amounts of technical know-how and pro tips from our community of Geo SCADA experts.
Originally published on Geo SCADA Knowledge Base by sbeadle1 | June 09, 2021 05:27 PM
Table Type | Unique Indices | Non-Unique Indices |
---|---|---|
Object | Id, FullName | ParentGroupId, Search Keys |
Aggregate | - | Id |
Alarm Condition | - | Id |
Event Journal | RecordId | Id, Source, FileId |
Point Historic | RecordId | Id |
Processed Historic | RecordId | Id |
Forecast Historic | RecordId | Id |
Data Grid | - | - |
Data Table | - | As configured |
Permits | Id, Name | - |
FullName LIKE '%Pump%'
RecordTime BETWEEN TIMESTAMP '2007-01-01 00:00:00' AND TIMESTAMP '2007-01-01 23:59:59'
Id = 123 OR Id = 456
Table Type | Scan Cost | Non-Unique Lookup Cost |
---|---|---|
Object | Object count / 100 | Average no. object per group, no. objects in search map |
Aggregate | Aggregate count / 100 | 1 |
Alarm Condition | Alarmable object count / 33 | 1 |
Event Journal | Total no. records | Average no. records per object |
Point Historic | - | Average no. records per point |
Processed Historic | - | Average no. records per point |
Forecast Historic | - | 100 |
Data Grid | No. rows in grid | - |
Data Table | No. rows in table | No. rows in table |
Permits | No. permits | - |
06-DEC-2007 11:49:42.578 0F8C [SCX] 2:12 Prepare( IN: GetColumnEnums false )06-DEC-2007 11:49:42.578 0F8C [SCX] 2:12 SQL: SELECT H.RecordId, H.RecordTime, H.Value FROM CDBHistoric AS H JOIN CDBPoint As P USING (Id)06-DEC-2007 11:49:42.593 0F8C [SCX] 2:12 (PHIL::CQPAccess) Join Permutation 0: CDBHISTORIC = Scan, CDBPOINT = Unique By Column; Cost = -106-DEC-2007 11:49:42.593 0F8C [SCX] 2:12 (PHIL::CQPAccess) Join Permutation 1: CDBPOINT = Scan, CDBHISTORIC = Non-Unique By Column; Cost = 18.206-DEC-2007 11:49:42.593 0F8C [SCX] 2:12 (PHIL::CQPAccess) Final Access Plan: CDBPOINT = Scan, CDBHISTORIC = Non-Unique By Column; Cost = 18.206-DEC-2007 11:49:42.593 0F8C [SCX] 2:12 Prepare( OUT: hr 0 -> Ok., TableId 0x2 )
Table Type | Constraint Columns | Required Form |
---|---|---|
Event Journal | Id, Source | Column = Value1 |
Event Journal | Id, Source | Column = Value1 OR Column = Value2 OR ... |
Event Journal | Source | Source LIKE Value1 |
Event Journal | Source | Source LIKE Value1 OR Source = Value2 |
Event Journal, Historic | RecordTime | RecordTime ''op'' Value1 (where ''op'' is any comparison operator other than <>) |
Create your free account or log in to subscribe to the forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.