IMO, neonate retics of any subspecies do best in tubs. SuperDwarf neonates are TINY, and should thrive in an appropriate tub setup. I'd advise a tub that's at least 12 inches tall though. I find that they are more arboreal and active the first year of their lives than after they become sub-adult to adults. Retics in general are more active than say, burms or balls, but I don't believe they require gigantic room-sized caging to thrive well in captivity.
For a true adult SD (which should grow no larger than 6ft or so, and be quite slender), I believe a 48Wx24Wx18-24(H) is perfect. You can still provide some low branches if the snake is inclined to climb, and the animal should have ample room to roam around or stretch out if it likes.
As far as the tub debate goes, I find most species of young snakes do very well when started in them, as opposed to aquariums or simply putting a tiny neonate in a huge cage. The tubs provide a sense of security, optimum temps and humidity. I'm not sure if the OP was suggesting housing and adult SD retic in a tub, but if he is, the only one that I think may be suitable is the VE175 tub sold by reptiletubs.com