Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

where clause performance if it has character field of length 100

former_member695534
Discoverer
0 Kudos

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?

1 ACCEPTED SOLUTION

Former Member

It will not have any effect on performance

3 REPLIES 3

former_member182550
Active Contributor
0 Kudos

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' ?

Former Member

It will not have any effect on performance

former_member695534
Discoverer
0 Kudos

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'