RE: does trafodion have null value in the index?

2017-06-01 Thread Rohit Jain
rules from what I understand. Rohit From: Anoop Sharma [mailto:anoop.sha...@esgyn.com] Sent: Thursday, June 1, 2017 10:04 AM To: user@trafodion.incubator.apache.org Subject: RE: does trafodion have null value in the index? traf indexes can be created on nullable columns and they can contain null

RE: does trafodion have null value in the index?

2017-06-01 Thread Anoop Sharma
ct b from t; B --- ? --- 1 row(s) selected. >> From: Liu, Ming (Ming) [mailto:ming@esgyn.cn] Sent: Wednesday, May 31, 2017 11:43 PM To: user@trafodion.incubator.apache.org Subject: does trafodion have null value in the index? Hi, all, I heard that database ind

does trafodion have null value in the index?

2017-06-01 Thread Liu, Ming (Ming)
Hi, all, I heard that database index cannot save null value, so if the predicate contains 'is null' 'is not null', then the index will not be used. Is this true for Trafodion as well? thanks, Ming