Index on hierarchical query

 Hello,

I wrote a hierarchical query on a GLOBAL TEMPORARY TABLE that have LEVEL in where condition.

 CURSOR CUR_TREE (CURRENT_LEVEL IN NUMBER)

      IS

             SELECT TABLE_PK,

                    TABLE_FK,

                    TABLE_XML

               FROM KID_XML_TREE_GTT

              WHERE LEVEL = CURRENT_LEVEL

         CONNECT BY PRIOR TABLE_PK = TABLE_FK

         START WITH TABLE_FK IS NULL;

I put the primary key on the column TABLE_PK and no more indexes.

Where I can put an index to make it faster? I have to remove the PK to make it faster?

Thanks