Search results for query: *

Mike I am transferring the foxpro data to Oracle... I am facing this problem in initial load... And I believe this problem will appear in incremental load too. I mean its not one time job.. I dont have any idea from where this orphans are getting added. as this application is 25 year old. And...

I also feel the same performance for this cannot be increased... is there any other way of finding how many orphans.. bu using relation ..or something else etc... you are telling 10 secs for 10 million records.. for me it is taking 10secs for 1 million records

Yes I have that index...good amount of data in transactional table 6 lakh records

I have already mentioned that I have index on a+b fields on transactional data and on a field on master data.

Olaf the below sql is taking 12 seconds ... the sqls you have provided is taking more time SELECT COUNT(*) FROM t1 WHERE t1.a + t1.b in ( select a FROM t1 ) INTO CURSOR t2 t1 has 35 fields index fields length is 11 chars and t2is a cursor has only one field

I need to have correct count of data in transactional table that matches the data in master table. I hope you understand Orphan records are not fully orphan.. which has value in key field but the value is not there in the master table In short I need reccount() of transactional data that...

Mike both are character fields earlier I used to get the record count using the reccount() - deleted records count. which was very faster. Now I have some orphan records in transactional data which is creating problem and I need to join the table with master data.

my query is select count(*) from t1 where t1.a +t1.b in ( select t2.a from t2) where t1 is transactional data t2 is master and t1 has index on a and b fields and t2 has index on a field my only problem is I need count of t1 data that matches t2 my query is taking 12 seconds when data is...

I have a performance problem I have two tables one is master other is transaction data. And transaction data record count is in more than 10 millions I need to get the the transaction data records count where the key field is in master. Please provide the best solution I have tried with joins...