Skip to Content
0
Former Member
Jun 02, 2008 at 08:21 PM

Select using where...Like clause Vs Download and process internal table

32 Views

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