CODEWITHSUNDEEP
sqlpostgresqldatabase-performance
John Alexander Betts
John Alexander Betts

Reputation: 5186

Are parenthesis needed to improve performance in postgresql?

Is really true that parenthesis in all conditions in postgresql improve performance?

Example:

SELECT field_1, field_2, ... , field_n
FROM table_x
WHERE ((field_x = a) AND (field_y = b) AND (field_z = c))

Upvotes: 1

Views: 101

Answers (1)

Mureinik
Mureinik

Reputation: 311018

In short - no. This statement is semantically equivalent to a statement without parenthesis, and there shouldn't be any noticeable performance difference between them.

Upvotes: 2

Related Questions