== Examples ==__NOEDITSECTION__
=== View my_view_hazardreductions in Afghanistan ===__NOEDITSECTION__
Version with a very poor performance (approx. 860 seconds/ 86'242 rows):
<pre>
SELECT type.enumvalue AS Type,
AND customdefinedfield.name = 'CDF-Clearance Type';
</pre>
Optimised version (approx. 160 seconds/ 86'242 rows):
<pre>
WITH hazreduc_imsmaenum AS (