Timeline for Rebuild large Oracle 10g index with insufficient TEMP space?
Current License: CC BY-SA 2.5
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 21, 2011 at 14:21 | comment | added | Adam Musch | Unless your dates aggregate really well, COMPRESS might not buy you much. Unless there are several NUMBERS for each distinct DATE, index compression adds overhead in both storage and processing. Have you considered instead partitioning the index? | |
| Mar 22, 2011 at 11:23 | history | tweeted | twitter.com/#!/StackDBAs/status/50155657147596800 | ||
| Mar 22, 2011 at 10:17 | answer | added | Gaius | timeline score: 10 | |
| Mar 22, 2011 at 9:56 | answer | added | user953 | timeline score: 1 | |
| Mar 22, 2011 at 9:25 | history | asked | Mike Woodhouse | CC BY-SA 2.5 |