This content has been marked as final. Show 2 replies
Looking into the present R-Tree index creation, I noticed that all the intermediate tables are created as permanent tables instead of temporary.
Why an earth does create index do this?
Creating the intermediate tables as temp tables should reduce the overall creation time significantly - what am I missing here?