Procedure 'Proc_Level3' calls procedure 'Proc_Level4'. Procedure 'Proc_Level4' populates a temp table. I created an index on the temp table. My 'create index' statement is in 'Proc_Level3'. The index keys are based on the columns used in the join statement (in Proc_Level3) that uses the temp table. However, the index is not being used. So, a table scan of the temp table is taking place. I tried creating the index in 'Proc_Level4' instead of 'Proc_Level3', still wasn't used. The number of rows in the temp table range between 25,000 - 50,000. Any suggestions? Thank you.