How does vertica perform when there are multiple conditions in the where statement?
- filter in order like a funnel, the result that satisfies the latter condition must satisfy the former condition, and the latter is a subset of the former
- or get the results of each condition separately and then take the intersection of them?
This is a sample. From the results, it seems that the second screening.