01-10-2019 1:36 PM
Is it ok to write select query with where clause to search by field of data element character 100. will it have any effect on performance?
01-10-2019 4:32 PM
01-10-2019 4:01 PM
Are you saying that you want to search by a data element that has a length of 100, or that you want to search by a data element using the character at position 100 ?
My question would be 'Why' ?
01-10-2019 4:32 PM
01-11-2019 2:50 PM
Thank you Rachid.
Richard - i mean will there be performance issue if i write a select query in which where clause field is of length 100 character length.example
SELECT * FROM ZTABLE into itab where field1 = 'XYEARAE..........upto 100 characters'