Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: number of rows returned from SELECT
- From: "Andrew Hammond" <andrew(dot)george(dot)hammond(at)gmail(dot)com>
- To: pgsql-novice(at)postgresql(dot)org
- Subject: Re: number of rows returned from SELECT
- Date: 28 Jul 2006 17:16:14 -0700
> What's the most efficient way of determining the number of rows that > _would_ be returned after/for a SELECT? Or is this impossible without... > actually... _doing_ a SELECT? You can't determine it without running the query. However you can ask for a estimate. Take a look at EXPLAIN.
- References:
- number of rows returned from SELECT
- From: Corey
- number of rows returned from SELECT
- Prev by Date: number of rows returned from SELECT
- Next by Date: Re: number of rows returned from SELECT
- Previous by thread: number of rows returned from SELECT
- Next by thread: Re: number of rows returned from SELECT
- Indexes: