Hello,
We need to select some records from a big database table depending upon the particular values of a big field.
The filed in the table is CHAR(80) and format is
xxx-xxx-xxxx-xxxxxxxxx-xxx-xx-xx , i.e. Some meaningful data separated by '-' , where one or multiple of these parts can be blank or non-blank.
So the options are
1) either use 'LIKE' operater in where clause of select statement and filter the records from database.
2) Get all the records into an internal table, loop and split and then do further processing.
Which method is more efficient in terms of system load and performance?
Thanks and regards,
Anand