In:
Clear[unitize, pick, n, data] RandomSeed[1]; n = -1; data = RandomChoice[Range[0, 10], {10^710^8, 3}]; AbsoluteTiming[Pick[data, Unitize@data[[All, n]], 1] // Length] unitize[x_] := unitize[x] = Unitize[x] pick[xs_, sel_, patt_] := pick[xs] = Pick[xs, sel, patt] AbsoluteTiming[pick[data, unitize@data[[All, n]], 1] // Length] Out:
{07.5211713081, 909064190913401} {05.45802887919, 909064190913401}