Skip site navigation (1)
Skip section navigation (2)
In other DBMSs indexes speed the process of sorting on a field in an ORDER BY clause if the same conditions for WHERE and JOIN clauses are met. I didn't see this mentioned in the docs on indexes though. Does an index also speed sorting as it does lookup in the other clauses?
Peripheral Links
Header And Logo
|
Site Navigation
Indexes to speed sorting
- From: Jeff Willden <jeff(at)pavanell(dot)com>
- To: pgsql-novice(at)postgresql(dot)org
- Subject: Indexes to speed sorting
- Date: Sat, 26 Jan 2008 09:21:19 -0700
In other DBMSs indexes speed the process of sorting on a field in an ORDER BY clause if the same conditions for WHERE and JOIN clauses are met. I didn't see this mentioned in the docs on indexes though. Does an index also speed sorting as it does lookup in the other clauses?
Jeff Willden
- Follow-Ups:
- Re: Indexes to speed sorting
- From: Jaime Casanova
- Re: Indexes to speed sorting
- Prev by Date: Re: Creating diff scripts for upgrades
- Next by Date: Re: Indexes to speed sorting
- Previous by thread: Newbie just starting on charting with PHP - and seeking advice on options/approaches
- Next by thread: Re: Indexes to speed sorting
- Indexes: