Anyone Ever add a non-clustered index to the tagid in the sqlt_data partition tables?

Ignition
1

When you look at the query is generated with system.tag.queryTagHistory(), it uses 'WHERE tagid IN (tagid1,tagid2....)

image
image904×107 5.24 KB

Curious if a clustered index might help speed up some of the queries that have a lot of tagids

Thanks!

2

Yes, a multicolumn index on t_stamp and tagid will help.

1 Like
3

Thanks!!!!