2 Replies Latest reply: Mar 31, 2014 9:37 AM by B Hall RSS

    Why does create index use non-temporary tables?

    B Hall

      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?

       

      Bryan