Re: [PERFORM] Building multiple indexes on one table.

2014-07-17 Thread Claudio Freire
On Thu, Jul 17, 2014 at 7:47 PM, Chris Ruprecht wrote: > Is there any way that I can build multiple indexes on one table without > having to scan the table multiple times? For small tables, that's probably > not an issue, but if I have a 500 GB table that I need to create 6 indexes > on, I don'

[PERFORM] Building multiple indexes on one table.

2014-07-17 Thread Chris Ruprecht
Is there any way that I can build multiple indexes on one table without having to scan the table multiple times? For small tables, that's probably not an issue, but if I have a 500 GB table that I need to create 6 indexes on, I don't want to read that table 6 times. Nothing I could find in the m