当前位置: 动力学知识库 > 问答 > 编程问答 >

postgresql - EXISTS subquery: SELECT 1 or SELECT * FROM X performant in Postgres?

问题描述:

This question already has an answer here:

  • What is easier to read in EXISTS subqueries? [closed]

    3 answers

网友答案:

Per the documentation:

Since the result depends only on whether any rows are returned, and not on the contents of those rows, the output list of the subquery is normally unimportant.

分享给朋友:
您可能感兴趣的文章:
随机阅读: