Remember to consider partial indexes:
eg. CREATE INDEX ON table (col) WHERE deletedate IS NOT
NULL
Chris
|
- [PERFORM] Indexing question Alexander Priem
- Re: [PERFORM] Indexing question Christopher Kings-Lynne
- Re: [PERFORM] Indexing question Tomasz Myrta
- Re: [PERFORM] Indexing question Alexander Priem
- Re: [PERFORM] Indexing question Tomasz Myrta
- Re: [PERFORM] Indexing question Alexander Priem
- Re: [PERFORM] Indexing quest... Tomasz Myrta
- Re: [PERFORM] Indexing q... Alexander Priem
- Re: [PERFORM] Indexi... Tom Lane
- Re: [PERFORM] Indexi... Alexander Priem
- Re: [PERFORM] Indexi... Richard Ellis
- Re: [PERFORM] Indexing question Christopher Kings-Lynne