Commiteb6af01

committed

Document that COUNT(*) might not need a seq scan any more.

Noted by Josh Kupershmidt.

1 parentdb6de5b commiteb6af01Copy full SHA for eb6af01

File tree

-2

lines changed

-2

lines changed

Lines changed: 4 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -11102,8 +11102,10 @@ SELECT b1 = ANY((SELECT b2 FROM t2 ...)) FROM t1 ...;`
`11102`	`11102`	`<programlisting>`
`11103`	`11103`	`SELECT count(*) FROM sometable;`
`11104`	`11104`	`</programlisting>`
`11105`		`- will be executed by <productname>PostgreSQL</productname> using a`
`11106`		`- sequential scan of the entire table.`
	`11105`	`+ will require effort proportional to the size of the table:`
	`11106`	`+ <productname>PostgreSQL</productname> will need to scan either the`
	`11107`	`+ entire table or the entirety of an index which includes all rows in`
	`11108`	`+ the table.`
`11107`	`11109`	`</para>`
`11108`	`11110`	`</note>`
`11109`	`11111`

Comments

(0)