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.
Link copied. Please paste this link to share this article on your social media post.
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 <>) |
Link copied. Please paste this link to share this article on your social media post.
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.