I have a question related to behavior of WITH queries.
So I have
WITH test as ( SELECT id, name, .... FROM test... WHERE ... )
In that auxiliary statement I select a column(s) that have index on them. So question is - If i select later on from test will it use that index?