I do use temporary indexes when I'm crunching large datasets. This is usually the case for our month-end reports. In one report it cut our execution time from over 8 minutes to under 2. Even when I use table variables I've found performance gains by declaring a Primary Key if I can.