Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #72.7K
|
I have around 2 million vouchers of some fixed denomination (say 10 and 20)[CODE]create table vouchers(pin varchar2(20) primary key ,amount number,status char(1),extra_value number); create index IDX_AMOUNT_STATUS on vouchers(amount,status);[/CODE]Typical values [CODE]amount,status ,count(status) 10 N 1000000 10 U 700000 20 N 300000 [/CODE]For each payment transaction,I fetch one voucher wrt.transaction amount and …
|