While working on migrating data out of IFS, we have noticed that ProjectTransactionSeq does not seem to be indexed in Apps10 UPD20. Is there some reason for excluding this key value from being indexed?
Or is the idea to use some other value that is actually indexed?
P.S. We are on Managed Cloud Services, so supported by the IFS Cloud.
Question
ProjectTransactionSeq - benefit of adding an index?
+7
+10I assume you are talking about the DB view project_transaction (Oracle table project_transaction_tab) and I don’t got your point what the issue is? The project_transaction_seq is the primary key of this table/view and this is always indexed.
Can you provide some more details please?
/Jens
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.