On 22 Oct 2007, at 15:16, Helen Borrie wrote:

> Even though Richard thinks he has resolved the performance problem
> by indexing the zipcode field(s), it doesn't address a worse one:
> the use of floating-point values as join criteria or, indeed, any
> equivalence search such as the pivot in what he refers to as
> "dimensional data". Such keys need to be stored as fixed types to
> avoid a (quite unknown) number of false negatives.

Is this caused by floating point representation issues? And would
this affect integer representations?
________________________________________________________
Richard Wesley Senior Software Developer Tableau
Software
Visit: http://www.trytableau.com/now.html