I am trying to get data from the transactions table. It is huge. I was told to never join it to another table or try to make a multitalble view with it. My attemps to write a query with it as a join timeout.

What should I do. They select into a temp table and then join the temp table.
I am sure the table is indexed, is there a way of using the index to speed up queries. I will be studing indexing this weekend.

Thanks for your help
Jim