...
- The wildcard for texts when using the LIKE statement is % (e.g. SELECT * FROM TimeSeries WHERE moduleInstanceId LIKE '%Import%')
- When looking for a date in an SQL string - use CAST('yyyy-MM-dd HH:mm:ss' as TIMESTAMP)
(this is equivalent to the ORACLE to_Date command) - More scripts and suggestions can be found here: How+to+optimize+the+size+of+the+database+-+using+queries+to+determine+the+size+of+the+different+components