In PANTHERVIEWS.PUBLIC.ALLRULEMATCHES
, what is the difference between table names ending in _current
vs _001
, _002
?
The_current
suffix indicates the most recent version of the SQL query (i.e., the results tied to the most recent SQL).
The _001
_002
etc. suffixes represent each iteration/version of the SQL query.
For example, If there's only one version, then the results in both tables (_current
and _001
) should be equal.