Skip to Content
Former Member
May 29, 2008 at 10:56 AM

Diference in time between Select using like 'X%' and a range with CP???


Hi Gurus,

Does anyone knows if there is significant diferent in time when using a select with the like adiction and using a range with the contains Patern ???

I trying to optimize a program, that is fecthing several thousands documents in BSAS, BSAK and BSAD and i've notice that the select condition is using a like adiction on these 3 selects... Can anyone tell me if i change the like to a range with the contains patern adiciton that the diference in time will be significant??

Thanks in Advance,