It'a slow even without indexes. In other cases, where the CTE is used multiple times in the same query, it can be faster