Skip to Content
0
Former Member
Feb 21, 2008 at 07:51 AM

reg: indexes

8 Views

Hi,

We created some tables suppose ztab.

It having primary key object key and some other fields.

Im following two approaches. which is the best one.

1.

select objectkey field2 field 3 into table it_ztab

where objectkey = p_objectkey

and date in s_date.

2.

select objectkey field2 field 3 into table it_ztab

where objectkey = p_objectkey.

delete it_ztab where date not in s_date.

What is ur comment.