Hi,
I am having a table T1 where in need to check all the columns whether they are having null values
T1
id number
dat_col date
amt number
I need to each columns if there are any null values
select * from T1
where (id is null or dat_col is null or amt is null);
Is there efficient way to check which column is having null along with data, because there is no indexes in any of the columns and there are around 150 billion records in T1