You're trying to return more than 56 million rows to the screen. The machine you're doing the query from has simply run out of memory.
Also, the "NCI_CHUB_S_CONTACT_01" is crazy. You've essentially rebuilt the table. Improving that won't help you running out of memory while returning 56 million rows to the screen, though.
--Jeff Moden
Change is inevitable... Change for the better is not.