[Chicago-talk] Design Question

[Jay Strauss]

JT Smith wrote:
> Let me add one more:
> 
> And IF you don't have 999,999,999,999,999,999,999,999 records in the table you're 
> polling.  Cuz then your index will still be absolutely enormous even though the index 
> values are relatively small.
> 
> 

** This is a generalization from my Oracle and Sybase Experience **  If 
the columns being indexed contain NULLs, then they are not included in 
the index.  Therefore, this particular index will only be 1 record, 
regardless of how big the table grows.

Jay