Memory foam vs. Sleep number - hammock effect?

Fred Head asked:

My wife and I are debating which mattress to get. My main question is for long term use. Will either mattress suffer from the hammock effect…. is there going to be a hole where we sleep?
Question posted courtesy of:

English flagItalian flagGerman flagSpanish flagFrench flagPortuguese flagJapanese flag
Korean flagChinese flagArabic flagRussian flag   
By N2H