Re: ** statistics for zero row table - Yes or No?

From: Kerry Osborne <>
Date: Sun, 23 Aug 2009 20:11:02 -0500
Message-Id: <>

Well put Ric. Of course on the other hand, why would you ever join to a table with no rows? Unless the zero row table is sometimes not a zero row table. Like if it's being used as a temp table that sometimes has rows and sometimes doesn't. In which case, dynamic sampling would actually be better than stats that are sometimes dead wrong.

Kerry Osborne

Received on Sun Aug 23 2009 - 20:11:02 CDT

Original text of this message