Skip to Content
0
Former Member
Jul 18, 2008 at 06:00 AM

Table

70 Views

Hi

I hv a Ztable haing 15 million records and now the situation has come to compare the all these records.

1.The problem is here how the 15 millions record would be kept in buffers,if I am use select * into table <> ?

2. Another alternate, I used select - endselect. somewht it works even taking around more than 20 mins to compare the record by using the secondary index. But the problem is it keeps some records like it netarea is the mandatory field , for 1 there should 100 records bt it shows only 67 like this.

3. table *<table> is obsolete and while syntax check it shows an error. ?

I would appreciate with reward points if any one help me

1. how the processing time can reduce?

2. How the Table can be called directly as Tables *<>?

3. during select - endselect why it keeps some records?