| Subject | Still About performance and running slow |
|---|---|
| Author | Allies Xposs |
| Post date | 2009-04-24T20:10:29Z |
hi all...
this basic question, but make me confuse....
I use interbase Suoer serve server 6.0, Page Size 1024.
and every 1 week i move record transaction to another database.
Because at table MYSS (Sales Transakstion Table) i keep under 20.000 record. this for performance my application.
But.. this nigth Running Slow... (my application Not responding)
If Index make a good performance :
what This Index and structure database have some wrong???
And i sent Statististic data at attachemnt Files...
Please correct me......
Thanksss
----------
Service started at 24/04/2009 7:28:59
Database "C:\data\MYXPOSSDB.GDB"
Database header page information:
Flags 0
Checksum 12345
Generation 8375
Page size 1024
ODS version 10.1
Oldest transaction 434
Oldest active 8366
Oldest snapshot 8366
Next transaction 8367
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Feb 5, 2009 5:13:44
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
Database file sequence:
File C:\data\MYXPOSSDB.GDB is the only file
Database log page information:
Creation date
Log flags: 2
No write ahead log
Next log page: 0
Variable log data:
Control Point 1:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
Control Point 2:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
Current File:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
*END*
Analyzing database pages ...
ACCESMENU (128)
Primary pointer page: 905, Index root page: 906
Data pages: 1, data page slots: 1, average fill: 18%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$FOREIGN25 (0)
Depth: 1, leaf buckets: 1, nodes: 3
Average data length: 11.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ACCESUSER (129)
Primary pointer page: 907, Index root page: 908
Data pages: 1, data page slots: 1, average fill: 23%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY1 (0)
Depth: 1, leaf buckets: 1, nodes: 1
Average data length: 3.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ACCESUSER2 (130)
Primary pointer page: 909, Index root page: 910
Data pages: 1, data page slots: 1, average fill: 40%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY2 (0)
Depth: 1, leaf buckets: 1, nodes: 2
Average data length: 2.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BILLSUM (131)
Primary pointer page: 911, Index root page: 912
Data pages: 8, data page slots: 8, average fill: 65%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 7
80 - 99% = 0
BINCARD (132)
Primary pointer page: 914, Index root page: 915
Data pages: 19, data page slots: 19, average fill: 57%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 18
60 - 79% = 0
80 - 99% = 0
BRAND (133)
Primary pointer page: 916, Index root page: 917
Data pages: 1, data page slots: 1, average fill: 24%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY3 (0)
Depth: 1, leaf buckets: 1, nodes: 6
Average data length: 3.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
CLAS (134)
Primary pointer page: 918, Index root page: 919
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
COMPANION (135)
Primary pointer page: 920, Index root page: 921
Data pages: 28, data page slots: 28, average fill: 63%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 27
80 - 99% = 0
CUSTOMER (136)
Primary pointer page: 922, Index root page: 923
Data pages: 1, data page slots: 1, average fill: 6%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY4 (0)
Depth: 1, leaf buckets: 1, nodes: 1
Average data length: 4.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DANCER (137)
Primary pointer page: 924, Index root page: 925
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DEPT (138)
Primary pointer page: 926, Index root page: 927
Data pages: 3, data page slots: 3, average fill: 50%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2
80 - 99% = 0
Index RDB$PRIMARY5 (0)
Depth: 1, leaf buckets: 1, nodes: 29
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DIV (139)
Primary pointer page: 928, Index root page: 929
Data pages: 1, data page slots: 1, average fill: 43%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY6 (0)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DTL (140)
Primary pointer page: 930, Index root page: 931
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DTLCKTL (141)
Primary pointer page: 933, Index root page: 934
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DTLFAKTUR (142)
Primary pointer page: 935, Index root page: 936
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
GL (143)
Primary pointer page: 937, Index root page: 938
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
HDR (144)
Primary pointer page: 939, Index root page: 940
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY7 (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
HDRCKTL (145)
Primary pointer page: 941, Index root page: 942
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
HDRFAKTUR (146)
Primary pointer page: 943, Index root page: 944
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
HISTBILL (147)
Primary pointer page: 945, Index root page: 946
Data pages: 4486, data page slots: 4486, average fill: 69%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4485
80 - 99% = 0
HISTORI (148)
Primary pointer page: 947, Index root page: 948
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
I2S (149)
Primary pointer page: 949, Index root page: 950
Data pages: 1, data page slots: 1, average fill: 11%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY8 (0)
Depth: 1, leaf buckets: 1, nodes: 1
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INFO (150)
Primary pointer page: 952, Index root page: 953
Data pages: 1, data page slots: 1, average fill: 7%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
IN_DTL (151)
Primary pointer page: 954, Index root page: 955
Data pages: 1, data page slots: 1, average fill: 21%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$FOREIGN26 (0)
Depth: 1, leaf buckets: 1, nodes: 3
Average data length: 12.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
IN_HDR (152)
Primary pointer page: 956, Index root page: 957
Data pages: 1, data page slots: 1, average fill: 33%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY9 (0)
Depth: 1, leaf buckets: 1, nodes: 6
Average data length: 11.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
LOGDBF (153)
Primary pointer page: 958, Index root page: 959
Data pages: 159, data page slots: 159, average fill: 53%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 158
60 - 79% = 0
80 - 99% = 0
LOGIN (154)
Primary pointer page: 960, Index root page: 961
Data pages: 4, data page slots: 4, average fill: 49%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 3
60 - 79% = 0
80 - 99% = 0
LOGPROSES (155)
Primary pointer page: 962, Index root page: 963
Data pages: 1, data page slots: 1, average fill: 15%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index LOGPROSES1 (0)
Depth: 1, leaf buckets: 1, nodes: 2
Average data length: 16.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index LOGPROSES2 (1)
Depth: 1, leaf buckets: 1, nodes: 2
Average data length: 9.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
LOKASI (156)
Primary pointer page: 964, Index root page: 965
Data pages: 1, data page slots: 1, average fill: 61%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
Index RDB$PRIMARY10 (0)
Depth: 1, leaf buckets: 1, nodes: 6
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MAMI (157)
Primary pointer page: 966, Index root page: 967
Data pages: 3, data page slots: 3, average fill: 60%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 2
80 - 99% = 0
MASTPOS (158)
Primary pointer page: 968, Index root page: 969
Data pages: 474, data page slots: 474, average fill: 79%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 300
80 - 99% = 174
MEJA (159)
Primary pointer page: 971, Index root page: 972
Data pages: 130, data page slots: 130, average fill: 81%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 39
80 - 99% = 90
Index MEJA1 (1)
Depth: 2, leaf buckets: 7, nodes: 800
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 6
Index RDB$PRIMARY11 (0)
Depth: 2, leaf buckets: 6, nodes: 800
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 6
MESS (160)
Primary pointer page: 973, Index root page: 974
Data pages: 1, data page slots: 1, average fill: 51%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
MIX (161)
Primary pointer page: 975, Index root page: 976
Data pages: 1, data page slots: 1, average fill: 10%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MNGMENU (162)
Primary pointer page: 977, Index root page: 978
Data pages: 2, data page slots: 2, average fill: 65%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2
80 - 99% = 0
Index RDB$PRIMARY12 (0)
Depth: 1, leaf buckets: 1, nodes: 28
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
MYBK (163)
Primary pointer page: 979, Index root page: 980
Data pages: 4, data page slots: 4, average fill: 62%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 3
80 - 99% = 0
MYBT (164)
Primary pointer page: 981, Index root page: 982
Data pages: 1086, data page slots: 1086, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 401
80 - 99% = 685
MYCHEF (231)
Primary pointer page: 1123, Index root page: 1124
Data pages: 1, data page slots: 1, average fill: 64%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
MYCR (165)
Primary pointer page: 983, Index root page: 984
Data pages: 2192, data page slots: 2192, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 845
80 - 99% = 1346
Index MYCR1 (0)
Depth: 2, leaf buckets: 72, nodes: 9250
Average data length: 0.00, total dup: 8207, max dup: 119
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 11
60 - 79% = 13
80 - 99% = 48
Index MYCR2 (1)
Depth: 2, leaf buckets: 73, nodes: 9250
Average data length: 0.00, total dup: 9228, max dup: 1721
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 32
60 - 79% = 2
80 - 99% = 39
Index MYCR3 (2)
Depth: 3, leaf buckets: 239, nodes: 9250
Average data length: 14.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 78
60 - 79% = 4
80 - 99% = 157
MYCR08 (166)
Primary pointer page: 985, Index root page: 986
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MYCV (167)
Primary pointer page: 987, Index root page: 988
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MYDBF (168)
Primary pointer page: 990, Index root page: 991
Data pages: 2, data page slots: 2, average fill: 48%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1
MYGENERATE (169)
Primary pointer page: 992, Index root page: 993
Data pages: 1, data page slots: 1, average fill: 22%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY13 (0)
Depth: 1, leaf buckets: 1, nodes: 6
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MYHK (170)
Primary pointer page: 994, Index root page: 995
Data pages: 10715, data page slots: 10715, average fill: 68%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 10714
80 - 99% = 0
MYJOIN (171)
Primary pointer page: 996, Index root page: 997
Data pages: 1, data page slots: 1, average fill: 6%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MYKITCHEN (230)
Primary pointer page: 1120, Index root page: 1121
Data pages: 760, data page slots: 760, average fill: 77%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 760
80 - 99% = 0
Index KITCHEN1 (1)
Depth: 2, leaf buckets: 54, nodes: 7360
Average data length: 1.00, total dup: 4818, max dup: 52
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 53
Index KITCHEN2 (2)
Depth: 3, leaf buckets: 161, nodes: 7360
Average data length: 14.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 161
Index MYKITC (0)
Depth: 2, leaf buckets: 46, nodes: 7360
Average data length: 0.00, total dup: 7331, max dup: 441
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 45
MYKITCHEN2 (232)
Primary pointer page: 1125, Index root page: 1126
Data pages: 564, data page slots: 564, average fill: 73%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 563
80 - 99% = 0
MYKK (172)
Primary pointer page: 998, Index root page: 999
Data pages: 14304, data page slots: 14304, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 6142
80 - 99% = 8161
MYOR (173)
Primary pointer page: 1000, Index root page: 1001
Data pages: 8245, data page slots: 8245, average fill: 83%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1246
80 - 99% = 6998
Index MYOR1 (0)
Depth: 3, leaf buckets: 327, nodes: 41856
Average data length: 1.00, total dup: 24822, max dup: 95
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 326
MYOR08 (227)
Primary pointer page: 1114, Index root page: 1115
Data pages: 4790, data page slots: 4790, average fill: 77%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4430
80 - 99% = 360
MYSG (174)
Primary pointer page: 1002, Index root page: 1003
Data pages: 463, data page slots: 463, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 103
80 - 99% = 360
MYSPHJ (175)
Primary pointer page: 1004, Index root page: 1005
Data pages: 63, data page slots: 63, average fill: 75%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 62
80 - 99% = 1
MYSS (176)
Primary pointer page: 1006, Index root page: 1007
Data pages: 1596, data page slots: 1596, average fill: 83%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 536
80 - 99% = 1060
Index MYSS1 (0)
Depth: 2, leaf buckets: 54, nodes: 6347
Average data length: 0.00, total dup: 5568, max dup: 119
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 11
60 - 79% = 17
80 - 99% = 26
Index MYSS2 (1)
Depth: 2, leaf buckets: 56, nodes: 6347
Average data length: 0.00, total dup: 6328, max dup: 1432
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 34
60 - 79% = 3
80 - 99% = 19
Index MYSS3 (2)
Depth: 2, leaf buckets: 58, nodes: 6347
Average data length: 1.00, total dup: 5272, max dup: 104
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 6
60 - 79% = 22
80 - 99% = 30
MYSS0208 (177)
Primary pointer page: 1009, Index root page: 1010
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MYSS08 (178)
Primary pointer page: 1011, Index root page: 1012
Data pages: 1, data page slots: 1, average fill: 21%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MYSV (179)
Primary pointer page: 1013, Index root page: 1014
Data pages: 3884, data page slots: 3884, average fill: 79%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2816
80 - 99% = 1068
MYSV08 (180)
Primary pointer page: 1015, Index root page: 1016
Data pages: 13, data page slots: 13, average fill: 84%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 3
80 - 99% = 10
MYTERM (229)
Primary pointer page: 1118, Index root page: 1119
Data pages: 2, data page slots: 2, average fill: 45%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
MYUPDATE (181)
Primary pointer page: 1017, Index root page: 1018
Data pages: 2, data page slots: 2, average fill: 34%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
MYURUT (182)
Primary pointer page: 1019, Index root page: 1020
Data pages: 1, data page slots: 1, average fill: 58%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
MYXX (183)
Primary pointer page: 1021, Index root page: 1022
Data pages: 8982, data page slots: 8982, average fill: 76%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 8971
80 - 99% = 10
PELAYAN (184)
Primary pointer page: 1023, Index root page: 1024
Data pages: 1, data page slots: 1, average fill: 17%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY14 (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 2.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
POINT (185)
Primary pointer page: 1025, Index root page: 1026
Data pages: 317, data page slots: 317, average fill: 66%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 42
60 - 79% = 275
80 - 99% = 0
POS00 (186)
Primary pointer page: 1028, Index root page: 1029
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
POS01 (187)
Primary pointer page: 1030, Index root page: 1031
Data pages: 277, data page slots: 277, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 164
80 - 99% = 112
Index POS011 (0)
Depth: 2, leaf buckets: 9, nodes: 1178
Average data length: 1.00, total dup: 3, max dup: 2
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 9
Index POS01NAMA (1)
Depth: 2, leaf buckets: 19, nodes: 1178
Average data length: 8.00, total dup: 52, max dup: 10
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 18
Index POS01NAMA1 (2)
Depth: 2, leaf buckets: 19, nodes: 1178
Average data length: 8.00, total dup: 52, max dup: 10
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 18
POS02 (188)
Primary pointer page: 1032, Index root page: 1033
Data pages: 283, data page slots: 283, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 174
80 - 99% = 108
Index POS02NAMA (1)
Depth: 2, leaf buckets: 19, nodes: 1201
Average data length: 8.00, total dup: 50, max dup: 10
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 18
Index POS02NAMA1 (2)
Depth: 2, leaf buckets: 19, nodes: 1201
Average data length: 8.00, total dup: 50, max dup: 10
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 18
Index POSO21 (0)
Depth: 2, leaf buckets: 10, nodes: 1201
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 9
POS03 (189)
Primary pointer page: 1034, Index root page: 1035
Data pages: 285, data page slots: 285, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 166
80 - 99% = 118
Index POS031 (0)
Depth: 2, leaf buckets: 10, nodes: 1215
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 9
Index POS03NAMA (1)
Depth: 2, leaf buckets: 19, nodes: 1215
Average data length: 8.00, total dup: 59, max dup: 10
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 18
Index POS03NAMA1 (2)
Depth: 2, leaf buckets: 19, nodes: 1215
Average data length: 8.00, total dup: 59, max dup: 10
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 18
POS04 (190)
Primary pointer page: 1036, Index root page: 1037
Data pages: 7, data page slots: 7, average fill: 84%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 6
Index POS041 (0)
Depth: 1, leaf buckets: 1, nodes: 34
Average data length: 2.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index POS04NAMA (1)
Depth: 1, leaf buckets: 1, nodes: 34
Average data length: 10.00, total dup: 1, max dup: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index POS04NAMA1 (2)
Depth: 1, leaf buckets: 1, nodes: 34
Average data length: 10.00, total dup: 1, max dup: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
POS05 (191)
Primary pointer page: 1038, Index root page: 1039
Data pages: 315, data page slots: 315, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 195
80 - 99% = 119
Index POS051 (0)
Depth: 2, leaf buckets: 11, nodes: 1343
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 10
Index POS05NAMA (1)
Depth: 2, leaf buckets: 21, nodes: 1343
Average data length: 8.00, total dup: 60, max dup: 10
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 20
Index POS05NAMA1 (2)
Depth: 2, leaf buckets: 21, nodes: 1343
Average data length: 8.00, total dup: 60, max dup: 10
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 20
POS06 (192)
Primary pointer page: 1040, Index root page: 1041
Data pages: 329, data page slots: 329, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 178
80 - 99% = 150
Index POS061 (0)
Depth: 2, leaf buckets: 12, nodes: 1466
Average data length: 1.00, total dup: 1, max dup: 1
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 11
Index POS06A (1)
Depth: 2, leaf buckets: 21, nodes: 1466
Average data length: 7.00, total dup: 64, max dup: 13
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 20
Index POS06NAMA (2)
Depth: 2, leaf buckets: 21, nodes: 1466
Average data length: 7.00, total dup: 64, max dup: 13
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 20
Index POS06NAMA1 (3)
Depth: 2, leaf buckets: 21, nodes: 1466
Average data length: 7.00, total dup: 65, max dup: 13
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 20
POS07 (193)
Primary pointer page: 1042, Index root page: 1043
Data pages: 303, data page slots: 303, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 173
80 - 99% = 129
Index POS071 (0)
Depth: 2, leaf buckets: 10, nodes: 1300
Average data length: 1.00, total dup: 1, max dup: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 10
Index POS07NAMA (1)
Depth: 2, leaf buckets: 20, nodes: 1300
Average data length: 8.00, total dup: 60, max dup: 10
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 20
Index POS07NAMA1 (2)
Depth: 2, leaf buckets: 20, nodes: 1300
Average data length: 8.00, total dup: 60, max dup: 10
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 20
POS08 (194)
Primary pointer page: 1044, Index root page: 1045
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index POS08NAMA (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index POS08NAMA1 (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
POS10 (195)
Primary pointer page: 1047, Index root page: 1048
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index POS10NAMA (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PO_DTL (196)
Primary pointer page: 1049, Index root page: 1050
Data pages: 2, data page slots: 2, average fill: 47%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
Index RDB$FOREIGN27 (0)
Depth: 1, leaf buckets: 1, nodes: 15
Average data length: 4.00, total dup: 9, max dup: 5
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PO_HDR (197)
Primary pointer page: 1051, Index root page: 1052
Data pages: 1, data page slots: 1, average fill: 51%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY15 (0)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 11.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PRTKITCHEN (228)
Primary pointer page: 1116, Index root page: 1117
Data pages: 99, data page slots: 99, average fill: 73%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 98
80 - 99% = 0
PR_DTL (198)
Primary pointer page: 1053, Index root page: 1054
Data pages: 1, data page slots: 1, average fill: 31%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$FOREIGN28 (0)
Depth: 1, leaf buckets: 1, nodes: 5
Average data length: 7.00, total dup: 2, max dup: 2
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PR_HDR (199)
Primary pointer page: 1055, Index root page: 1056
Data pages: 1, data page slots: 1, average fill: 18%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY16 (0)
Depth: 1, leaf buckets: 1, nodes: 3
Average data length: 12.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RC_DTL (200)
Primary pointer page: 1057, Index root page: 1058
Data pages: 2, data page slots: 2, average fill: 57%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1
80 - 99% = 0
Index RDB$FOREIGN29 (0)
Depth: 1, leaf buckets: 1, nodes: 16
Average data length: 3.00, total dup: 11, max dup: 5
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RC_HDR (201)
Primary pointer page: 1059, Index root page: 1060
Data pages: 1, data page slots: 1, average fill: 35%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY17 (0)
Depth: 1, leaf buckets: 1, nodes: 5
Average data length: 11.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
REVENUE (202)
Primary pointer page: 1061, Index root page: 1062
Data pages: 1, data page slots: 1, average fill: 28%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RPTHDR (203)
Primary pointer page: 1063, Index root page: 1064
Data pages: 1, data page slots: 1, average fill: 6%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SALES (204)
Primary pointer page: 1066, Index root page: 1067
Data pages: 4, data page slots: 4, average fill: 67%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0
Index SALES1 (0)
Depth: 1, leaf buckets: 1, nodes: 44
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SALESITEM (205)
Primary pointer page: 1068, Index root page: 1069
Data pages: 1, data page slots: 1, average fill: 74%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
SCHPOINT (206)
Primary pointer page: 1070, Index root page: 1071
Data pages: 1, data page slots: 1, average fill: 28%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SECURITY (207)
Primary pointer page: 1072, Index root page: 1073
Data pages: 28, data page slots: 28, average fill: 93%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 27
Index SECURITY1 (0)
Depth: 2, leaf buckets: 4, nodes: 371
Average data length: 3.00, total dup: 8, max dup: 2
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 3
SLSEMPLOYEE (208)
Primary pointer page: 1074, Index root page: 1075
Data pages: 1, data page slots: 1, average fill: 9%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SOAPISSUES (209)
Primary pointer page: 1076, Index root page: 1077
Data pages: 1, data page slots: 1, average fill: 14%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY18 (0)
Depth: 1, leaf buckets: 1, nodes: 3
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SOAPRESOLUTION (210)
Primary pointer page: 1078, Index root page: 1079
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
STROOKE (211)
Primary pointer page: 1080, Index root page: 1081
Data pages: 11, data page slots: 11, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1
80 - 99% = 9
Index RDB$PRIMARY19 (0)
Depth: 1, leaf buckets: 1, nodes: 41
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SUBDEPT (212)
Primary pointer page: 1082, Index root page: 1083
Data pages: 8, data page slots: 8, average fill: 71%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 7
80 - 99% = 0
Index RDB$PRIMARY20 (0)
Depth: 1, leaf buckets: 1, nodes: 85
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
SUMBILL (213)
Primary pointer page: 1085, Index root page: 1086
Data pages: 2, data page slots: 2, average fill: 58%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1
80 - 99% = 0
Index SUMBILL1 (0)
Depth: 1, leaf buckets: 1, nodes: 12
Average data length: 4.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SUMMARY (214)
Primary pointer page: 1087, Index root page: 1088
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SUMPAY (215)
Primary pointer page: 1089, Index root page: 1090
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SUPPLIER (216)
Primary pointer page: 1091, Index root page: 1092
Data pages: 1, data page slots: 1, average fill: 14%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY21 (0)
Depth: 1, leaf buckets: 1, nodes: 2
Average data length: 2.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TABEL (217)
Primary pointer page: 1093, Index root page: 1094
Data pages: 1, data page slots: 1, average fill: 55%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
TGLRP (218)
Primary pointer page: 1095, Index root page: 1096
Data pages: 1, data page slots: 1, average fill: 40%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TODAYEVENT (219)
Primary pointer page: 1097, Index root page: 1098
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TR_DTL (220)
Primary pointer page: 1099, Index root page: 1100
Data pages: 1, data page slots: 1, average fill: 30%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$FOREIGN30 (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 9.00, total dup: 2, max dup: 2
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TR_HDR (221)
Primary pointer page: 1101, Index root page: 1102
Data pages: 1, data page slots: 1, average fill: 9%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY22 (0)
Depth: 1, leaf buckets: 1, nodes: 2
Average data length: 19.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TSGROUP (222)
Primary pointer page: 1104, Index root page: 1105
Data pages: 1, data page slots: 1, average fill: 17%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TSMENU (223)
Primary pointer page: 1106, Index root page: 1107
Data pages: 382, data page slots: 382, average fill: 75%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 381
80 - 99% = 0
TSMENUX (224)
Primary pointer page: 1108, Index root page: 1109
Data pages: 60, data page slots: 60, average fill: 74%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 59
80 - 99% = 0
URUT (225)
Primary pointer page: 1110, Index root page: 1111
Data pages: 1, data page slots: 1, average fill: 16%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY23 (0)
Depth: 1, leaf buckets: 1, nodes: 6
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
WAITER (226)
Primary pointer page: 1112, Index root page: 1113
Data pages: 33, data page slots: 33, average fill: 74%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 33
80 - 99% = 0
Index RDB$PRIMARY24 (0)
Depth: 2, leaf buckets: 4, nodes: 356
Average data length: 2.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 3
Service ended at 24/04/2009 7:29:37
----------
SET SQL DIALECT 3;
/* CREATE DATABASE 'C:\data\MYXPOSSDB.GDB' PAGE_SIZE 1024
DEFAULT CHARACTER SET NONE */
/* Table: ACCESMENU, Owner: SYSDBA */
CREATE TABLE "ACCESMENU"
(
"USERID" VARCHAR(10) NOT NULL,
"M_NAMA" VARCHAR(30) NOT NULL,
"M_ACTION" INTEGER DEFAULT 0,
"M_LEVEL" INTEGER,
"M_BMP" INTEGER
);
/* Table: ACCESUSER, Owner: SYSDBA */
CREATE TABLE "ACCESUSER"
(
"USERID" VARCHAR(10) NOT NULL,
"MAIN1" VARCHAR(1),
"MAIN2" VARCHAR(1),
"MAIN3" VARCHAR(1),
"MAIN4" VARCHAR(1),
"MAIN5" VARCHAR(1),
"MAIN6" VARCHAR(1),
"MAIN7" VARCHAR(1),
"MAIN8" VARCHAR(1),
"MAIN9" VARCHAR(1),
"MAIN10" VARCHAR(1),
"MAIN11" VARCHAR(1),
"MAIN12" VARCHAR(1),
"MAIN13" VARCHAR(1),
"MAIN14" VARCHAR(1),
"MAIN15" VARCHAR(1),
"MAIN16" VARCHAR(1),
"MAIN17" VARCHAR(1),
"MAIN18" VARCHAR(1),
"MAIN19" VARCHAR(1),
"MAIN20" VARCHAR(1),
"MAIN21" VARCHAR(1),
"MAIN22" VARCHAR(1),
"MAIN23" VARCHAR(1),
"MAIN24" VARCHAR(1),
"MAIN25" VARCHAR(1),
"MAIN26" VARCHAR(1),
"MAIN27" VARCHAR(1),
"MAIN28" VARCHAR(1),
"MAIN29" VARCHAR(1),
"MAIN30" VARCHAR(1),
"MAIN31" VARCHAR(1),
"MAIN32" VARCHAR(1),
"MAIN33" VARCHAR(1),
"MAIN34" VARCHAR(1),
"MAIN35" VARCHAR(1),
"MAIN36" VARCHAR(1),
"MAIN37" VARCHAR(1),
"MAIN38" VARCHAR(1),
"MAIN39" VARCHAR(1),
"MAIN40" VARCHAR(1),
"MAIN41" VARCHAR(1),
"MAIN42" VARCHAR(1),
"MAIN43" VARCHAR(1),
"MAIN44" VARCHAR(1),
"MAIN45" VARCHAR(1),
"MAIN46" VARCHAR(1),
"MAIN47" VARCHAR(1),
"MAIN48" VARCHAR(1),
"MAIN49" VARCHAR(1),
"MAIN50" VARCHAR(1),
"MAIN51" VARCHAR(1),
"MAIN52" VARCHAR(1),
"MAIN53" VARCHAR(1),
"MAIN54" VARCHAR(1),
"MAIN55" VARCHAR(1),
"MAIN56" VARCHAR(1),
"MAIN57" VARCHAR(1),
"MAIN58" VARCHAR(1),
"MAIN59" VARCHAR(1),
"MAIN60" VARCHAR(1),
"MAIN61" VARCHAR(1),
"MAIN62" VARCHAR(1),
"MAIN63" VARCHAR(1),
"MAIN64" VARCHAR(1),
"MAIN65" VARCHAR(1),
"MAIN66" VARCHAR(1),
"MAIN67" VARCHAR(1),
"MAIN68" VARCHAR(1),
"MAIN69" VARCHAR(1),
"MAIN70" VARCHAR(1),
"MAIN71" VARCHAR(1),
"MAIN72" VARCHAR(1),
"MAIN73" VARCHAR(1),
"MAIN74" VARCHAR(1),
"MAIN75" VARCHAR(1),
"MAIN76" VARCHAR(1),
"MAIN77" VARCHAR(1),
"MAIN78" VARCHAR(1),
"MAIN79" VARCHAR(1),
"MAIN80" VARCHAR(1),
"MAIN81" VARCHAR(1),
"MAIN82" VARCHAR(1),
"MAIN83" VARCHAR(1),
"MAIN84" VARCHAR(1),
"MAIN85" VARCHAR(1),
"MAIN86" VARCHAR(1),
"MAIN87" VARCHAR(1),
"MAIN88" VARCHAR(1),
"MAIN89" VARCHAR(1),
"MAIN90" VARCHAR(1),
"MAIN91" VARCHAR(1),
"MAIN92" VARCHAR(1),
"MAIN93" VARCHAR(1),
"MAIN94" VARCHAR(1),
"MAIN95" VARCHAR(1),
"MAIN96" VARCHAR(1),
"MAIN97" VARCHAR(1),
"MAIN98" VARCHAR(1),
"MAIN99" VARCHAR(1),
"MAIN100" VARCHAR(1),
"MAIN101" VARCHAR(1),
"MAIN102" VARCHAR(1),
"MAIN103" VARCHAR(1),
"MAIN104" VARCHAR(1),
"MAIN105" VARCHAR(1),
"MAIN106" VARCHAR(1),
"MAIN107" VARCHAR(1),
"MAIN108" VARCHAR(1),
"MAIN109" VARCHAR(1),
"MAIN110" VARCHAR(1),
"MAIN111" VARCHAR(1),
"MAIN112" VARCHAR(1),
"MAIN113" VARCHAR(1),
"MAIN114" VARCHAR(1),
"MAIN115" VARCHAR(1),
"MAIN116" VARCHAR(1),
"MAIN117" VARCHAR(1),
"MAIN118" VARCHAR(1),
"MAIN119" VARCHAR(1),
"MAIN120" VARCHAR(1),
"MAIN121" VARCHAR(1),
"MAIN122" VARCHAR(1),
"MAIN123" VARCHAR(1),
"MAIN124" VARCHAR(1),
"MAIN125" VARCHAR(1),
"MAIN126" VARCHAR(1),
"MAIN127" VARCHAR(1),
"MAIN128" VARCHAR(1),
"MAIN129" VARCHAR(1),
"MAIN130" VARCHAR(1),
"MAIN131" VARCHAR(1),
"MAIN132" VARCHAR(1),
"MAIN133" VARCHAR(1),
"MAIN134" VARCHAR(1),
"MAIN135" VARCHAR(1),
"MAIN136" VARCHAR(1),
"MAIN137" VARCHAR(1),
"MAIN138" VARCHAR(1),
"MAIN139" VARCHAR(1),
"MAIN140" VARCHAR(1),
"MAIN141" VARCHAR(1),
"MAIN142" VARCHAR(1),
"MAIN143" VARCHAR(1),
"MAIN144" VARCHAR(1),
"MAIN145" VARCHAR(1),
"MAIN146" VARCHAR(1),
"MAIN147" VARCHAR(1),
"MAIN148" VARCHAR(1),
"MAIN149" VARCHAR(1),
"MAIN150" VARCHAR(1),
"MAIN151" VARCHAR(1),
"MAIN152" VARCHAR(1),
"MAIN153" VARCHAR(1),
"MAIN154" VARCHAR(1),
"MAIN155" VARCHAR(1),
"MAIN156" VARCHAR(1),
"MAIN157" VARCHAR(1),
"MAIN158" VARCHAR(1),
"MAIN159" VARCHAR(1),
"MAIN160" VARCHAR(1),
"MAIN161" VARCHAR(1),
"MAIN162" VARCHAR(1),
"MAIN163" VARCHAR(1),
"MAIN164" VARCHAR(1),
"MAIN165" VARCHAR(1),
"MAIN166" VARCHAR(1),
"MAIN167" VARCHAR(1),
"MAIN168" VARCHAR(1),
"MAIN169" VARCHAR(1),
"MAIN170" VARCHAR(1),
"MAIN171" VARCHAR(1),
"MAIN172" VARCHAR(1),
"MAIN173" VARCHAR(1),
"MAIN174" VARCHAR(1),
PRIMARY KEY ("USERID")
);
/* Table: BILLSUM, Owner: SYSDBA */
CREATE TABLE "BILLSUM"
(
"P_LOK" VARCHAR(2),
"P_TGL" DATE,
"P_BON" VARCHAR(6),
"P_MEJA" VARCHAR(4),
"CASHIER" VARCHAR(10),
"TIPE" VARCHAR(10),
"CASH" DOUBLE PRECISION DEFAULT 0,
"CARD1" DOUBLE PRECISION DEFAULT 0,
"SIGNBILL" DOUBLE PRECISION DEFAULT 0,
"VOUCHER" DOUBLE PRECISION DEFAULT 0,
"DEPOSIT" DOUBLE PRECISION DEFAULT 0,
"POINT" INTEGER DEFAULT 0,
"PAX" INTEGER DEFAULT 0
);
/* Table: COMPANION, Owner: SYSDBA */
CREATE TABLE "COMPANION"
(
"C_KODE" VARCHAR(5),
"C_NAMA" VARCHAR(30),
"C_ALAMAT" VARCHAR(50),
"C_TELP" VARCHAR(20),
"C_STATUS" VARCHAR(1) DEFAULT '0',
"C_MAMI" VARCHAR(10)
);
/* Table: CUSTOMER, Owner: SYSDBA */
CREATE TABLE "CUSTOMER"
(
"C_KODE" VARCHAR(5) NOT NULL,
"C_NAMA" VARCHAR(25) DEFAULT ' ',
"C_ALAMAT" VARCHAR(40) DEFAULT ' ',
"C_ALAMAT2" VARCHAR(40) DEFAULT ' ',
"C_KOTA" VARCHAR(20) DEFAULT ' ',
"C_KOTA2" VARCHAR(20) DEFAULT ' ',
"C_TELP" VARCHAR(20) DEFAULT ' ',
"C_TERM" INTEGER DEFAULT 0,
"C_KONTAK" VARCHAR(20) DEFAULT ' ',
"C_NPWP" VARCHAR(20),
"C_LIMIT" DOUBLE PRECISION DEFAULT 0,
"C_KREDIT" DOUBLE PRECISION DEFAULT 0,
"C_USER" VARCHAR(10) DEFAULT ' ',
PRIMARY KEY ("C_KODE")
);
/* Table: DANCER, Owner: SYSDBA */
CREATE TABLE "DANCER"
(
"D_CODE" VARCHAR(5),
"D_NAMA" VARCHAR(30),
"D_ALAMAT" VARCHAR(50),
"D_TELP" VARCHAR(15),
"DEPT1" VARCHAR(3),
"DEPT2" VARCHAR(3),
"DEPT3" VARCHAR(3),
"DEPT4" VARCHAR(3),
"D_ACTIVE" VARCHAR(1) DEFAULT '0',
"D_MAMI" VARCHAR(10)
);
/* Table: DEPT, Owner: SYSDBA */
CREATE TABLE "DEPT"
(
"DIV_CODE" VARCHAR(1),
"DEPT_CODE" VARCHAR(2) NOT NULL,
"DEPT_DESC" VARCHAR(30),
"USERBY" VARCHAR(10) DEFAULT ' ',
PRIMARY KEY ("DEPT_CODE")
);
/* Table: DIV, Owner: SYSDBA */
CREATE TABLE "DIV"
(
"DIV_CODE" VARCHAR(1) NOT NULL,
"DIV_DESC" VARCHAR(30),
"USERBY" VARCHAR(10) DEFAULT ' ',
"D_MIX" VARCHAR(1) DEFAULT ' ',
PRIMARY KEY ("DIV_CODE")
);
/* Table: LOKASI, Owner: SYSDBA */
CREATE TABLE "LOKASI"
(
"LOK_CODE" VARCHAR(2) NOT NULL,
"LOK_DESC" VARCHAR(20),
"L_POS" VARCHAR(5),
"LOK_SEGMEN" INTEGER DEFAULT 0,
"LOK_ZONE" INTEGER DEFAULT 0,
"LOK_NAMA" VARCHAR(20),
"LOK_ALAMAT" VARCHAR(30),
"LOK_AREA" VARCHAR(20),
"LOK_TELP" VARCHAR(15),
"LOK_NPWP" VARCHAR(15),
"USERBY" VARCHAR(10) DEFAULT ' ',
"POS" VARCHAR(1) DEFAULT '0',
"LOKBMP" VARCHAR(50) DEFAULT '',
"TOTAL" VARCHAR(1) DEFAULT '0',
"FACILITY" VARCHAR(1) DEFAULT '0',
PRIMARY KEY ("LOK_CODE")
);
/* Table: MASTPOS, Owner: SYSDBA */
CREATE TABLE "MASTPOS"
(
"M_NOREG" VARCHAR(10) DEFAULT '0',
"M_DIV" VARCHAR(1) DEFAULT ' ',
"M_DEPT" VARCHAR(2) DEFAULT ' ',
"M_SDEPT" VARCHAR(4) DEFAULT ' ',
"M_STOCK" VARCHAR(1) DEFAULT '1',
"M_HEADER" VARCHAR(1) DEFAULT '0',
"M_PKP" VARCHAR(1) DEFAULT '0',
"M_SKU" VARCHAR(8) DEFAULT ' ',
"M_SKU2" VARCHAR(4) DEFAULT ' ',
"M_NAMA" VARCHAR(50) DEFAULT ' ',
"M_NAMAS" VARCHAR(30) DEFAULT ' ',
"M_CRT" INTEGER DEFAULT 1,
"M_BOX" INTEGER DEFAULT 0,
"M_PCS" INTEGER DEFAULT 0,
"M_SIZE" VARCHAR(15) DEFAULT ' ',
"M_DIS" INTEGER DEFAULT 0,
"M_DIS2" INTEGER DEFAULT 0,
"M_KOM" VARCHAR(1) DEFAULT '0',
"M_PPN" INTEGER DEFAULT 0,
"M_SVC" INTEGER DEFAULT 0,
"M_USER" VARCHAR(10) DEFAULT ' ',
"M_BRAND" VARCHAR(4) DEFAULT ' ',
"M_ACTIVE" VARCHAR(1) DEFAULT '0',
"M_SELL1" INTEGER DEFAULT 0,
"M_SELL2" INTEGER DEFAULT 0,
"M_SELL3" INTEGER DEFAULT 0,
"M_MINSTOCK" INTEGER DEFAULT 0,
"M_MAXSTOCK" INTEGER DEFAULT 0,
"M_COST" DOUBLE PRECISION DEFAULT 0,
"M_TGLC" DATE DEFAULT 'NOW',
"M_TGLC2" DATE DEFAULT 'NOW',
"M_TGLC3" DATE DEFAULT 'NOW',
"M_TGLC4" DATE DEFAULT 'NOW'
);
/* Table: MEJA, Owner: SYSDBA */
CREATE TABLE "MEJA"
(
"CODE_MEJA" VARCHAR(5) NOT NULL,
"DESC_MEJA" VARCHAR(30),
"TYPE_MEJA" VARCHAR(1) DEFAULT 0,
"STATUS_MEJA" VARCHAR(1) DEFAULT 0,
"MCHG1_MEJA" INTEGER NOT NULL,
"MCHG2_MEJA" INTEGER NOT NULL,
"M_LOK" VARCHAR(2),
"PAX" INTEGER,
"GUEST" VARCHAR(30),
"JAM_IN" TIME,
"LINE" INTEGER,
"BILL" VARCHAR(1) DEFAULT '0',
"CODE_MEJA2" VARCHAR(5) DEFAULT '',
"USERBY" VARCHAR(10) DEFAULT ' ',
"M_PPN" INTEGER DEFAULT 0,
"M_SVC" INTEGER DEFAULT 0,
"M_PAKET" INTEGER DEFAULT 1,
"TOP" INTEGER DEFAULT 0,
"POSLEFT" INTEGER DEFAULT 0,
"INFO" VARCHAR(1) DEFAULT '0',
"WIDTH" INTEGER DEFAULT 40,
"HEIGHT" INTEGER DEFAULT 40,
"LAYOUT" VARCHAR(1) DEFAULT '0',
"M_JAM1" TIME DEFAULT '13:00:00',
"M_JAM2" TIME DEFAULT '19:59:59',
"M_JAM" TIME DEFAULT 'NOW',
"FACILITY" VARCHAR(1) DEFAULT '0',
"SESSION" VARCHAR(1) DEFAULT '0',
"TMPDAILY" VARCHAR(1),
"DAILY" VARCHAR(1) default '0',
"SESION" INTEGER DEFAULT 1,
PRIMARY KEY ("CODE_MEJA")
);
/* Table: MESS, Owner: SYSDBA */
CREATE TABLE "MESS"
(
"MESS" VARCHAR(30),
"STATUS" VARCHAR(10)
);
/* Table: MIX, Owner: SYSDBA */
CREATE TABLE "MIX"
(
"M_CODE" VARCHAR(1),
"M_DESC" VARCHAR(10)
);
/* Table: MNGMENU, Owner: SYSDBA */
CREATE TABLE "MNGMENU"
(
"M_NAMA" VARCHAR(30) NOT NULL,
"M_ACTION" INTEGER,
"M_BMP" INTEGER,
"M_LEVEL" INTEGER,
PRIMARY KEY ("M_NAMA")
);
/* Table: MYCHEF, Owner: SYSDBA */
CREATE TABLE "MYCHEF"
(
"C_KODE" VARCHAR(3) Default '-',
"C_NAMA" VARCHAR(30) default ' ',
"C_ACTIVE" VARCHAR(1) default '0'
);
/* Table: MYKITCHEN, Owner: SYSDBA */
CREATE TABLE "MYKITCHEN"
(
"P_TGL" DATE Default 'now',
"P_LOK" VARCHAR(2) default ' ',
"P_ORD" VARCHAR(6) default ' ',
"P_SKU" VARCHAR(8) default ' ',
"P_QTY" INTEGER default 0,
"P_CHEF" VARCHAR(10) default ' ',
"START1" TIMESTAMP,
"P_START" TIMESTAMP default 'now',
"P_END" TIMESTAMP default 'now',
"P_WAKTU" COMPUTED BY ((p_end-p_start)*(24*3600))
);
/* Table: MYKITCHEN2, Owner: SYSDBA */
CREATE TABLE "MYKITCHEN2"
(
"P_TGL" DATE Default 'now',
"P_LOK" VARCHAR(2) default ' ',
"P_ORD" VARCHAR(6) default ' ',
"P_SKU" VARCHAR(8) default ' ',
"P_QTY" INTEGER default 0,
"P_CHEF" VARCHAR(10) default ' ',
"P_START" TIME default 'now',
"P_END" TIME default 'now',
"P_WAKTU" COMPUTED BY ((p_end-p_start)*(24*3600))
);
/* Table: MYOR, Owner: SYSDBA */
CREATE TABLE "MYOR"
(
"O_TGL" DATE,
"O_NOMOR" VARCHAR(6),
"O_NOREG" VARCHAR(4),
"O_PELAY" VARCHAR(10),
"O_JAM1" INTEGER,
"O_JAM2" INTEGER,
"O_MEM" VARCHAR(30),
"O_PAX" INTEGER DEFAULT 0,
"O_MEJA" VARCHAR(4),
"O_JAMT1" INTEGER DEFAULT 0,
"O_JAMT2" INTEGER DEFAULT 0,
"O_USER" VARCHAR(10),
"O_FLAG2" VARCHAR(1),
"O_BON" VARCHAR(7),
"O_TELP" VARCHAR(15),
"O_JAMIN" TIME,
"O_FLAG" VARCHAR(1) DEFAULT ' ',
"O_JAMOUT" TIME,
"O_MEJA2" VARCHAR(5) DEFAULT ' ',
"O_LOK" VARCHAR(2) DEFAULT '00',
"O_JAMPKT" INTEGER DEFAULT '0',
"O_TIMEOUT" TIME DEFAULT '00:00:00',
"P_EOD" VARCHAR(1) DEFAULT '0',
"WAKTU" INTEGER DEFAULT 0,
"O_DATEIN" DATE DEFAULT 'NOW',
"O_DATEOUT" DATE DEFAULT 'NOW',
"ADDRESS" VARCHAR(50) DEFAULT ' ',
"NATIONALITY" VARCHAR(20) DEFAULT ' ',
"TEMPAT" VARCHAR(30) DEFAULT ' ',
"TGLLHR" DATE DEFAULT 'NOW',
"IDNO" VARCHAR(20) DEFAULT ' ',
"PHONE" VARCHAR(30) DEFAULT ' ',
"DEPOSIT" DOUBLE PRECISION DEFAULT 0,
"CARDDEPOSIT" DOUBLE PRECISION DEFAULT 0,
"NOCARD" VARCHAR(16) DEFAULT ' ',
"NAMECARD" VARCHAR(30) DEFAULT ' ',
"VOUCHER" DOUBLE PRECISION DEFAULT 0,
"O_TGLCO" DATE,
"O_ENT" VARCHAR(1) DEFAULT '0'
);
/* Table: MYSS, Owner: SYSDBA */
CREATE TABLE "MYSS"
(
"P_TGL" DATE,
"P_PDMEJ" VARCHAR(4) DEFAULT ' ',
"P_PDOLE" VARCHAR(10) DEFAULT ' ',
"P_PDJAM" VARCHAR(8) DEFAULT ' ',
"P_LOK" VARCHAR(2) DEFAULT ' ',
"P_BAR" VARCHAR(2) DEFAULT ' ',
"P_TERM" VARCHAR(2) DEFAULT ' ',
"P_MEJA" VARCHAR(4) DEFAULT ' ',
"P_ORD" VARCHAR(6) DEFAULT ' ',
"P_BON" VARCHAR(7) DEFAULT ' ',
"P_MEMBER" VARCHAR(6) DEFAULT ' ',
"P_NRP" VARCHAR(10) DEFAULT ' ',
"P_PELAY" VARCHAR(10) DEFAULT ' ',
"P_SIF" VARCHAR(1) DEFAULT ' ',
"P_SKU" VARCHAR(8) DEFAULT ' ',
"P_QTY" INTEGER DEFAULT 0,
"P_SEL2" DOUBLE PRECISION DEFAULT 0,
"P_SEL" DOUBLE PRECISION DEFAULT 0,
"P_DIS" INTEGER DEFAULT 0,
"P_DIS1" INTEGER DEFAULT 0,
"P_END" VARCHAR(10) DEFAULT ' ',
"P_PAX" INTEGER DEFAULT 0,
"P_PPN" INTEGER DEFAULT 0,
"P_SVC" INTEGER DEFAULT 0,
"P_TERIMA" VARCHAR(1) DEFAULT ' ',
"P_CETAK" VARCHAR(1) DEFAULT ' ',
"P_PEND" VARCHAR(10) DEFAULT ' ',
"P_JAM" TIME,
"P_FLAG" VARCHAR(1) DEFAULT ' ',
"SDEPT_CODE" VARCHAR(3) DEFAULT ' ',
"P_PISAH" INTEGER DEFAULT 0,
"P_EOD" VARCHAR(1) DEFAULT '0',
"P_CDIS" VARCHAR(1) DEFAULT ' ',
"P_PKP" VARCHAR(1) DEFAULT '0',
"STATUS" INTEGER DEFAULT 0,
"P_CHGDIS" VARCHAR(1) DEFAULT '0',
"INFO" VARCHAR(30) DEFAULT '',
"PRINTTO" VARCHAR(20) DEFAULT '',
"P_USER2" VARCHAR(10) DEFAULT '',
"P_CO" VARCHAR(1) DEFAULT '0',
"P_TGLCO" DATE,
"P_COMP" VARCHAR(10) DEFAULT '',
"STPRINT" VARCHAR(1) DEFAULT '0',
"P_JAAM" TIME DEFAULT '00:00:00',
"P_KITC" VARCHAR(1) DEFAULT '0'
);
/* Table: MYTERM, Owner: SYSDBA */
CREATE TABLE "MYTERM"
(
"P_TERM" VARCHAR(2),
"P_LOK" VARCHAR(2),
"P_PRINT" VARCHAR(40)
);
/* Table: MYUPDATE, Owner: SYSDBA */
CREATE TABLE "MYUPDATE"
(
"FRESH" VARCHAR(1)
);
/* Table: MYURUT, Owner: SYSDBA */
CREATE TABLE "MYURUT"
(
"LOK" VARCHAR(3) DEFAULT ' ',
"NO_ORDER" INTEGER DEFAULT 0,
"NO_BILL" INTEGER DEFAULT 0,
"PO" INTEGER DEFAULT 0,
"RC" INTEGER DEFAULT 0,
"PR" INTEGER DEFAULT 0,
"BT" INTEGER DEFAULT 0,
"SR" INTEGER DEFAULT 0,
"REG" INTEGER DEFAULT 0,
"RES" INTEGER DEFAULT 0
);
/* Table: MYXX, Owner: SYSDBA */
CREATE TABLE "MYXX"
(
"TGL" DATE DEFAULT 'now',
"LOK" VARCHAR(2) DEFAULT '',
"MEJAFROM" VARCHAR(4) DEFAULT '',
"MEJATO" VARCHAR(4) DEFAULT '',
"SKU" VARCHAR(8) DEFAULT '',
"QTY" INTEGER DEFAULT 0,
"ORD" VARCHAR(6) DEFAULT '',
"TERM" VARCHAR(2),
"USERBY" VARCHAR(10),
"APP" VARCHAR(10),
"WAKTU" TIME
);
/* Table: POINT, Owner: SYSDBA */
CREATE TABLE "POINT"
(
"TGL" DATE DEFAULT 'NOW',
"CARD" VARCHAR(16) DEFAULT '',
"UANG" DOUBLE PRECISION DEFAULT 0,
"PERSENT" INTEGER DEFAULT 0,
"POINT" INTEGER DEFAULT 0,
"SISA" DOUBLE PRECISION
);
/* Table: POS01, Owner: SYSDBA */
CREATE TABLE "POS01"
(
"M_GROUP" VARCHAR(4) DEFAULT ' ',
"M_SKU" VARCHAR(8) DEFAULT ' ',
"M_SKU2" VARCHAR(4) DEFAULT ' ',
"M_NAMA" VARCHAR(21) DEFAULT ' ',
"M_NAMAS" VARCHAR(21) DEFAULT ' ',
"M_BOX" INTEGER DEFAULT 0,
"M_PCS" INTEGER DEFAULT 0,
"M_SIZE" VARCHAR(8) DEFAULT ' ',
"M_DIS" INTEGER DEFAULT 0,
"M_DIS2" INTEGER DEFAULT 0,
"M_SELL1" INTEGER DEFAULT 0,
"M_SELL2" INTEGER DEFAULT 0,
"M_SELL3" INTEGER DEFAULT 0,
"M_KOM" VARCHAR(1) DEFAULT ' ',
"M_MEMBER" VARCHAR(1) DEFAULT ' ',
"M_DIS3" INTEGER DEFAULT 0,
"M_MIX" VARCHAR(1) DEFAULT ' ',
"M_TOMIX" VARCHAR(1) DEFAULT ' ',
"M_PPN" INTEGER DEFAULT 0,
"M_SVC" INTEGER DEFAULT 0,
"PRINT" VARCHAR(30) DEFAULT 'LPT1',
"M_PKP" VARCHAR(1) DEFAULT '0',
"M_CHANGE" VARCHAR(1) DEFAULT '0',
"M_JAM1" TIME DEFAULT '00:00:00',
"M_JAM2" TIME DEFAULT '23:59:59',
"M_JAM3" TIME DEFAULT '00:00:00',
"M_JAM4" TIME DEFAULT '23:59:59',
"M_CRT" INTEGER DEFAULT 0,
"M_USER" VARCHAR(10) DEFAULT ' ',
"M_BRAND" VARCHAR(4) DEFAULT ' ',
"M_HEADER" VARCHAR(1) DEFAULT '0',
"SDEPT" VARCHAR(4),
"STDISC" VARCHAR(1) DEFAULT '0',
"VDISCMEMBER" INTEGER DEFAULT 0,
"MEMBER" VARCHAR(1) DEFAULT '0'
);
/* Table: POS02, Owner: SYSDBA */
CREATE TABLE "POS02"
(
"M_GROUP" VARCHAR(4) DEFAULT ' ',
"M_SKU" VARCHAR(8) DEFAULT ' ',
"M_SKU2" VARCHAR(4) DEFAULT ' ',
"M_NAMA" VARCHAR(21) DEFAULT ' ',
"M_NAMAS" VARCHAR(21) DEFAULT ' ',
"M_BOX" INTEGER DEFAULT 0,
"M_PCS" INTEGER DEFAULT 0,
"M_SIZE" VARCHAR(8) DEFAULT ' ',
"M_DIS" INTEGER DEFAULT 0,
"M_DIS2" INTEGER DEFAULT 0,
"M_SELL1" INTEGER DEFAULT 0,
"M_SELL2" INTEGER DEFAULT 0,
"M_SELL3" INTEGER DEFAULT 0,
"M_KOM" VARCHAR(1) DEFAULT ' ',
"M_MEMBER" VARCHAR(1) DEFAULT ' ',
"M_DIS3" INTEGER DEFAULT 0,
"M_MIX" VARCHAR(1) DEFAULT ' ',
"M_TOMIX" VARCHAR(1) DEFAULT ' ',
"M_PPN" INTEGER DEFAULT 0,
"M_SVC" INTEGER DEFAULT 0,
"PRINT" VARCHAR(30) DEFAULT 'LPT1',
"M_PKP" VARCHAR(1) DEFAULT '0',
"M_CHANGE" VARCHAR(1) DEFAULT '0',
"M_JAM1" TIME DEFAULT '00:00:00',
"M_JAM2" TIME DEFAULT '23:59:59',
"M_JAM3" TIME DEFAULT '00:00:00',
"M_JAM4" TIME DEFAULT '23:59:59',
"M_CRT" INTEGER DEFAULT 0,
"M_USER" VARCHAR(10) DEFAULT ' ',
"M_BRAND" VARCHAR(4) DEFAULT ' ',
"M_HEADER" VARCHAR(1) DEFAULT '0',
"SDEPT" VARCHAR(4),
"STDISC" VARCHAR(1) DEFAULT '0',
"VDISCMEMBER" INTEGER DEFAULT 0,
"MEMBER" VARCHAR(1) DEFAULT '0'
);
/* Table: POS03, Owner: SYSDBA */
CREATE TABLE "POS03"
(
"M_GROUP" VARCHAR(4) DEFAULT ' ',
"M_SKU" VARCHAR(8) DEFAULT ' ',
"M_SKU2" VARCHAR(4) DEFAULT ' ',
"M_NAMA" VARCHAR(21) DEFAULT ' ',
"M_NAMAS" VARCHAR(21) DEFAULT ' ',
"M_BOX" INTEGER DEFAULT 0,
"M_PCS" INTEGER DEFAULT 0,
"M_SIZE" VARCHAR(8) DEFAULT ' ',
"M_DIS" INTEGER DEFAULT 0,
"M_DIS2" INTEGER DEFAULT 0,
"M_SELL1" INTEGER DEFAULT 0,
"M_SELL2" INTEGER DEFAULT 0,
"M_SELL3" INTEGER DEFAULT 0,
"M_KOM" VARCHAR(1) DEFAULT ' ',
"M_MEMBER" VARCHAR(1) DEFAULT ' ',
"M_DIS3" INTEGER DEFAULT 0,
"M_MIX" VARCHAR(1) DEFAULT ' ',
"M_TOMIX" VARCHAR(1) DEFAULT ' ',
"M_PPN" INTEGER DEFAULT 0,
"M_SVC" INTEGER DEFAULT 0,
"PRINT" VARCHAR(30) DEFAULT 'LPT1',
"M_PKP" VARCHAR(1) DEFAULT '0',
"M_CHANGE" VARCHAR(1) DEFAULT '0',
"M_JAM1" TIME DEFAULT '00:00:00',
"M_JAM2" TIME DEFAULT '23:59:59',
"M_JAM3" TIME DEFAULT '00:00:00',
"M_JAM4" TIME DEFAULT '23:59:59',
"M_CRT" INTEGER DEFAULT 0,
"M_USER" VARCHAR(10) DEFAULT ' ',
"M_BRAND" VARCHAR(4) DEFAULT ' ',
"M_HEADER" VARCHAR(1) DEFAULT '0',
"SDEPT" VARCHAR(4),
"STDISC" VARCHAR(1) DEFAULT '0',
"VDISCMEMBER" INTEGER DEFAULT 0,
"MEMBER" VARCHAR(1) DEFAULT '0'
);
/* Table: POS05, Owner: SYSDBA */
CREATE TABLE "POS05"
(
"M_GROUP" VARCHAR(4) DEFAULT ' ',
"M_SKU" VARCHAR(8) DEFAULT ' ',
"M_SKU2" VARCHAR(4) DEFAULT ' ',
"M_NAMA" VARCHAR(21) DEFAULT ' ',
"M_NAMAS" VARCHAR(21) DEFAULT ' ',
"M_BOX" INTEGER DEFAULT 0,
"M_PCS" INTEGER DEFAULT 0,
"M_SIZE" VARCHAR(8) DEFAULT ' ',
"M_DIS" INTEGER DEFAULT 0,
"M_DIS2" INTEGER DEFAULT 0,
"M_SELL1" INTEGER DEFAULT 0,
"M_SELL2" INTEGER DEFAULT 0,
"M_SELL3" INTEGER DEFAULT 0,
"M_KOM" VARCHAR(1) DEFAULT ' ',
"M_MEMBER" VARCHAR(1) DEFAULT ' ',
"M_DIS3" INTEGER DEFAULT 0,
"M_MIX" VARCHAR(1) DEFAULT ' ',
"M_TOMIX" VARCHAR(1) DEFAULT ' ',
"M_PPN" INTEGER DEFAULT 0,
"M_SVC" INTEGER DEFAULT 0,
"PRINT" VARCHAR(30) DEFAULT 'LPT1',
"M_PKP" VARCHAR(1) DEFAULT '0',
"M_CHANGE" VARCHAR(1) DEFAULT '0',
"M_JAM1" TIME DEFAULT '00:00:00',
"M_JAM2" TIME DEFAULT '23:59:59',
"M_JAM3" TIME DEFAULT '00:00:00',
"M_JAM4" TIME DEFAULT '23:59:59',
"M_CRT" INTEGER DEFAULT 0,
"M_USER" VARCHAR(10) DEFAULT ' ',
"M_BRAND" VARCHAR(4) DEFAULT ' ',
"M_HEADER" VARCHAR(1) DEFAULT '0',
"SDEPT" VARCHAR(4),
"STDISC" VARCHAR(1) DEFAULT '0',
"VDISCMEMBER" INTEGER DEFAULT 0,
"MEMBER" VARCHAR(1) DEFAULT '0'
);
/* Table: POS06, Owner: SYSDBA */
CREATE TABLE "POS06"
(
"M_GROUP" VARCHAR(4) DEFAULT ' ',
"M_SKU" VARCHAR(8) DEFAULT ' ',
"M_SKU2" VARCHAR(4) DEFAULT ' ',
"M_NAMA" VARCHAR(21) DEFAULT ' ',
"M_NAMAS" VARCHAR(21) DEFAULT ' ',
"M_BOX" INTEGER DEFAULT 0,
"M_PCS" INTEGER DEFAULT 0,
"M_SIZE" VARCHAR(8) DEFAULT ' ',
"M_DIS" INTEGER DEFAULT 0,
"M_DIS2" INTEGER DEFAULT 0,
"M_SELL1" INTEGER DEFAULT 0,
"M_SELL2" INTEGER DEFAULT 0,
"M_SELL3" INTEGER DEFAULT 0,
"M_KOM" VARCHAR(1) DEFAULT ' ',
"M_MEMBER" VARCHAR(1) DEFAULT ' ',
"M_DIS3" INTEGER DEFAULT 0,
"M_MIX" VARCHAR(1) DEFAULT ' ',
"M_TOMIX" VARCHAR(1) DEFAULT ' ',
"M_PPN" INTEG<br/><br/>(Message over 64 KB, truncated)
this basic question, but make me confuse....
I use interbase Suoer serve server 6.0, Page Size 1024.
and every 1 week i move record transaction to another database.
Because at table MYSS (Sales Transakstion Table) i keep under 20.000 record. this for performance my application.
But.. this nigth Running Slow... (my application Not responding)
If Index make a good performance :
what This Index and structure database have some wrong???
And i sent Statististic data at attachemnt Files...
Please correct me......
Thanksss
----------
Service started at 24/04/2009 7:28:59
Database "C:\data\MYXPOSSDB.GDB"
Database header page information:
Flags 0
Checksum 12345
Generation 8375
Page size 1024
ODS version 10.1
Oldest transaction 434
Oldest active 8366
Oldest snapshot 8366
Next transaction 8367
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Feb 5, 2009 5:13:44
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
Database file sequence:
File C:\data\MYXPOSSDB.GDB is the only file
Database log page information:
Creation date
Log flags: 2
No write ahead log
Next log page: 0
Variable log data:
Control Point 1:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
Control Point 2:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
Current File:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
*END*
Analyzing database pages ...
ACCESMENU (128)
Primary pointer page: 905, Index root page: 906
Data pages: 1, data page slots: 1, average fill: 18%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$FOREIGN25 (0)
Depth: 1, leaf buckets: 1, nodes: 3
Average data length: 11.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ACCESUSER (129)
Primary pointer page: 907, Index root page: 908
Data pages: 1, data page slots: 1, average fill: 23%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY1 (0)
Depth: 1, leaf buckets: 1, nodes: 1
Average data length: 3.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ACCESUSER2 (130)
Primary pointer page: 909, Index root page: 910
Data pages: 1, data page slots: 1, average fill: 40%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY2 (0)
Depth: 1, leaf buckets: 1, nodes: 2
Average data length: 2.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BILLSUM (131)
Primary pointer page: 911, Index root page: 912
Data pages: 8, data page slots: 8, average fill: 65%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 7
80 - 99% = 0
BINCARD (132)
Primary pointer page: 914, Index root page: 915
Data pages: 19, data page slots: 19, average fill: 57%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 18
60 - 79% = 0
80 - 99% = 0
BRAND (133)
Primary pointer page: 916, Index root page: 917
Data pages: 1, data page slots: 1, average fill: 24%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY3 (0)
Depth: 1, leaf buckets: 1, nodes: 6
Average data length: 3.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
CLAS (134)
Primary pointer page: 918, Index root page: 919
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
COMPANION (135)
Primary pointer page: 920, Index root page: 921
Data pages: 28, data page slots: 28, average fill: 63%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 27
80 - 99% = 0
CUSTOMER (136)
Primary pointer page: 922, Index root page: 923
Data pages: 1, data page slots: 1, average fill: 6%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY4 (0)
Depth: 1, leaf buckets: 1, nodes: 1
Average data length: 4.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DANCER (137)
Primary pointer page: 924, Index root page: 925
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DEPT (138)
Primary pointer page: 926, Index root page: 927
Data pages: 3, data page slots: 3, average fill: 50%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2
80 - 99% = 0
Index RDB$PRIMARY5 (0)
Depth: 1, leaf buckets: 1, nodes: 29
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DIV (139)
Primary pointer page: 928, Index root page: 929
Data pages: 1, data page slots: 1, average fill: 43%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY6 (0)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DTL (140)
Primary pointer page: 930, Index root page: 931
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DTLCKTL (141)
Primary pointer page: 933, Index root page: 934
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DTLFAKTUR (142)
Primary pointer page: 935, Index root page: 936
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
GL (143)
Primary pointer page: 937, Index root page: 938
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
HDR (144)
Primary pointer page: 939, Index root page: 940
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY7 (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
HDRCKTL (145)
Primary pointer page: 941, Index root page: 942
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
HDRFAKTUR (146)
Primary pointer page: 943, Index root page: 944
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
HISTBILL (147)
Primary pointer page: 945, Index root page: 946
Data pages: 4486, data page slots: 4486, average fill: 69%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4485
80 - 99% = 0
HISTORI (148)
Primary pointer page: 947, Index root page: 948
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
I2S (149)
Primary pointer page: 949, Index root page: 950
Data pages: 1, data page slots: 1, average fill: 11%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY8 (0)
Depth: 1, leaf buckets: 1, nodes: 1
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INFO (150)
Primary pointer page: 952, Index root page: 953
Data pages: 1, data page slots: 1, average fill: 7%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
IN_DTL (151)
Primary pointer page: 954, Index root page: 955
Data pages: 1, data page slots: 1, average fill: 21%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$FOREIGN26 (0)
Depth: 1, leaf buckets: 1, nodes: 3
Average data length: 12.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
IN_HDR (152)
Primary pointer page: 956, Index root page: 957
Data pages: 1, data page slots: 1, average fill: 33%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY9 (0)
Depth: 1, leaf buckets: 1, nodes: 6
Average data length: 11.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
LOGDBF (153)
Primary pointer page: 958, Index root page: 959
Data pages: 159, data page slots: 159, average fill: 53%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 158
60 - 79% = 0
80 - 99% = 0
LOGIN (154)
Primary pointer page: 960, Index root page: 961
Data pages: 4, data page slots: 4, average fill: 49%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 3
60 - 79% = 0
80 - 99% = 0
LOGPROSES (155)
Primary pointer page: 962, Index root page: 963
Data pages: 1, data page slots: 1, average fill: 15%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index LOGPROSES1 (0)
Depth: 1, leaf buckets: 1, nodes: 2
Average data length: 16.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index LOGPROSES2 (1)
Depth: 1, leaf buckets: 1, nodes: 2
Average data length: 9.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
LOKASI (156)
Primary pointer page: 964, Index root page: 965
Data pages: 1, data page slots: 1, average fill: 61%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
Index RDB$PRIMARY10 (0)
Depth: 1, leaf buckets: 1, nodes: 6
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MAMI (157)
Primary pointer page: 966, Index root page: 967
Data pages: 3, data page slots: 3, average fill: 60%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 2
80 - 99% = 0
MASTPOS (158)
Primary pointer page: 968, Index root page: 969
Data pages: 474, data page slots: 474, average fill: 79%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 300
80 - 99% = 174
MEJA (159)
Primary pointer page: 971, Index root page: 972
Data pages: 130, data page slots: 130, average fill: 81%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 39
80 - 99% = 90
Index MEJA1 (1)
Depth: 2, leaf buckets: 7, nodes: 800
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 6
Index RDB$PRIMARY11 (0)
Depth: 2, leaf buckets: 6, nodes: 800
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 6
MESS (160)
Primary pointer page: 973, Index root page: 974
Data pages: 1, data page slots: 1, average fill: 51%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
MIX (161)
Primary pointer page: 975, Index root page: 976
Data pages: 1, data page slots: 1, average fill: 10%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MNGMENU (162)
Primary pointer page: 977, Index root page: 978
Data pages: 2, data page slots: 2, average fill: 65%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2
80 - 99% = 0
Index RDB$PRIMARY12 (0)
Depth: 1, leaf buckets: 1, nodes: 28
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
MYBK (163)
Primary pointer page: 979, Index root page: 980
Data pages: 4, data page slots: 4, average fill: 62%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 3
80 - 99% = 0
MYBT (164)
Primary pointer page: 981, Index root page: 982
Data pages: 1086, data page slots: 1086, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 401
80 - 99% = 685
MYCHEF (231)
Primary pointer page: 1123, Index root page: 1124
Data pages: 1, data page slots: 1, average fill: 64%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
MYCR (165)
Primary pointer page: 983, Index root page: 984
Data pages: 2192, data page slots: 2192, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 845
80 - 99% = 1346
Index MYCR1 (0)
Depth: 2, leaf buckets: 72, nodes: 9250
Average data length: 0.00, total dup: 8207, max dup: 119
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 11
60 - 79% = 13
80 - 99% = 48
Index MYCR2 (1)
Depth: 2, leaf buckets: 73, nodes: 9250
Average data length: 0.00, total dup: 9228, max dup: 1721
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 32
60 - 79% = 2
80 - 99% = 39
Index MYCR3 (2)
Depth: 3, leaf buckets: 239, nodes: 9250
Average data length: 14.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 78
60 - 79% = 4
80 - 99% = 157
MYCR08 (166)
Primary pointer page: 985, Index root page: 986
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MYCV (167)
Primary pointer page: 987, Index root page: 988
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MYDBF (168)
Primary pointer page: 990, Index root page: 991
Data pages: 2, data page slots: 2, average fill: 48%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1
MYGENERATE (169)
Primary pointer page: 992, Index root page: 993
Data pages: 1, data page slots: 1, average fill: 22%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY13 (0)
Depth: 1, leaf buckets: 1, nodes: 6
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MYHK (170)
Primary pointer page: 994, Index root page: 995
Data pages: 10715, data page slots: 10715, average fill: 68%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 10714
80 - 99% = 0
MYJOIN (171)
Primary pointer page: 996, Index root page: 997
Data pages: 1, data page slots: 1, average fill: 6%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MYKITCHEN (230)
Primary pointer page: 1120, Index root page: 1121
Data pages: 760, data page slots: 760, average fill: 77%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 760
80 - 99% = 0
Index KITCHEN1 (1)
Depth: 2, leaf buckets: 54, nodes: 7360
Average data length: 1.00, total dup: 4818, max dup: 52
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 53
Index KITCHEN2 (2)
Depth: 3, leaf buckets: 161, nodes: 7360
Average data length: 14.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 161
Index MYKITC (0)
Depth: 2, leaf buckets: 46, nodes: 7360
Average data length: 0.00, total dup: 7331, max dup: 441
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 45
MYKITCHEN2 (232)
Primary pointer page: 1125, Index root page: 1126
Data pages: 564, data page slots: 564, average fill: 73%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 563
80 - 99% = 0
MYKK (172)
Primary pointer page: 998, Index root page: 999
Data pages: 14304, data page slots: 14304, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 6142
80 - 99% = 8161
MYOR (173)
Primary pointer page: 1000, Index root page: 1001
Data pages: 8245, data page slots: 8245, average fill: 83%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1246
80 - 99% = 6998
Index MYOR1 (0)
Depth: 3, leaf buckets: 327, nodes: 41856
Average data length: 1.00, total dup: 24822, max dup: 95
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 326
MYOR08 (227)
Primary pointer page: 1114, Index root page: 1115
Data pages: 4790, data page slots: 4790, average fill: 77%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4430
80 - 99% = 360
MYSG (174)
Primary pointer page: 1002, Index root page: 1003
Data pages: 463, data page slots: 463, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 103
80 - 99% = 360
MYSPHJ (175)
Primary pointer page: 1004, Index root page: 1005
Data pages: 63, data page slots: 63, average fill: 75%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 62
80 - 99% = 1
MYSS (176)
Primary pointer page: 1006, Index root page: 1007
Data pages: 1596, data page slots: 1596, average fill: 83%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 536
80 - 99% = 1060
Index MYSS1 (0)
Depth: 2, leaf buckets: 54, nodes: 6347
Average data length: 0.00, total dup: 5568, max dup: 119
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 11
60 - 79% = 17
80 - 99% = 26
Index MYSS2 (1)
Depth: 2, leaf buckets: 56, nodes: 6347
Average data length: 0.00, total dup: 6328, max dup: 1432
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 34
60 - 79% = 3
80 - 99% = 19
Index MYSS3 (2)
Depth: 2, leaf buckets: 58, nodes: 6347
Average data length: 1.00, total dup: 5272, max dup: 104
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 6
60 - 79% = 22
80 - 99% = 30
MYSS0208 (177)
Primary pointer page: 1009, Index root page: 1010
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MYSS08 (178)
Primary pointer page: 1011, Index root page: 1012
Data pages: 1, data page slots: 1, average fill: 21%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MYSV (179)
Primary pointer page: 1013, Index root page: 1014
Data pages: 3884, data page slots: 3884, average fill: 79%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2816
80 - 99% = 1068
MYSV08 (180)
Primary pointer page: 1015, Index root page: 1016
Data pages: 13, data page slots: 13, average fill: 84%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 3
80 - 99% = 10
MYTERM (229)
Primary pointer page: 1118, Index root page: 1119
Data pages: 2, data page slots: 2, average fill: 45%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
MYUPDATE (181)
Primary pointer page: 1017, Index root page: 1018
Data pages: 2, data page slots: 2, average fill: 34%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
MYURUT (182)
Primary pointer page: 1019, Index root page: 1020
Data pages: 1, data page slots: 1, average fill: 58%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
MYXX (183)
Primary pointer page: 1021, Index root page: 1022
Data pages: 8982, data page slots: 8982, average fill: 76%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 8971
80 - 99% = 10
PELAYAN (184)
Primary pointer page: 1023, Index root page: 1024
Data pages: 1, data page slots: 1, average fill: 17%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY14 (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 2.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
POINT (185)
Primary pointer page: 1025, Index root page: 1026
Data pages: 317, data page slots: 317, average fill: 66%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 42
60 - 79% = 275
80 - 99% = 0
POS00 (186)
Primary pointer page: 1028, Index root page: 1029
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
POS01 (187)
Primary pointer page: 1030, Index root page: 1031
Data pages: 277, data page slots: 277, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 164
80 - 99% = 112
Index POS011 (0)
Depth: 2, leaf buckets: 9, nodes: 1178
Average data length: 1.00, total dup: 3, max dup: 2
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 9
Index POS01NAMA (1)
Depth: 2, leaf buckets: 19, nodes: 1178
Average data length: 8.00, total dup: 52, max dup: 10
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 18
Index POS01NAMA1 (2)
Depth: 2, leaf buckets: 19, nodes: 1178
Average data length: 8.00, total dup: 52, max dup: 10
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 18
POS02 (188)
Primary pointer page: 1032, Index root page: 1033
Data pages: 283, data page slots: 283, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 174
80 - 99% = 108
Index POS02NAMA (1)
Depth: 2, leaf buckets: 19, nodes: 1201
Average data length: 8.00, total dup: 50, max dup: 10
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 18
Index POS02NAMA1 (2)
Depth: 2, leaf buckets: 19, nodes: 1201
Average data length: 8.00, total dup: 50, max dup: 10
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 18
Index POSO21 (0)
Depth: 2, leaf buckets: 10, nodes: 1201
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 9
POS03 (189)
Primary pointer page: 1034, Index root page: 1035
Data pages: 285, data page slots: 285, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 166
80 - 99% = 118
Index POS031 (0)
Depth: 2, leaf buckets: 10, nodes: 1215
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 9
Index POS03NAMA (1)
Depth: 2, leaf buckets: 19, nodes: 1215
Average data length: 8.00, total dup: 59, max dup: 10
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 18
Index POS03NAMA1 (2)
Depth: 2, leaf buckets: 19, nodes: 1215
Average data length: 8.00, total dup: 59, max dup: 10
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 18
POS04 (190)
Primary pointer page: 1036, Index root page: 1037
Data pages: 7, data page slots: 7, average fill: 84%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 6
Index POS041 (0)
Depth: 1, leaf buckets: 1, nodes: 34
Average data length: 2.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index POS04NAMA (1)
Depth: 1, leaf buckets: 1, nodes: 34
Average data length: 10.00, total dup: 1, max dup: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index POS04NAMA1 (2)
Depth: 1, leaf buckets: 1, nodes: 34
Average data length: 10.00, total dup: 1, max dup: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
POS05 (191)
Primary pointer page: 1038, Index root page: 1039
Data pages: 315, data page slots: 315, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 195
80 - 99% = 119
Index POS051 (0)
Depth: 2, leaf buckets: 11, nodes: 1343
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 10
Index POS05NAMA (1)
Depth: 2, leaf buckets: 21, nodes: 1343
Average data length: 8.00, total dup: 60, max dup: 10
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 20
Index POS05NAMA1 (2)
Depth: 2, leaf buckets: 21, nodes: 1343
Average data length: 8.00, total dup: 60, max dup: 10
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 20
POS06 (192)
Primary pointer page: 1040, Index root page: 1041
Data pages: 329, data page slots: 329, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 178
80 - 99% = 150
Index POS061 (0)
Depth: 2, leaf buckets: 12, nodes: 1466
Average data length: 1.00, total dup: 1, max dup: 1
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 11
Index POS06A (1)
Depth: 2, leaf buckets: 21, nodes: 1466
Average data length: 7.00, total dup: 64, max dup: 13
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 20
Index POS06NAMA (2)
Depth: 2, leaf buckets: 21, nodes: 1466
Average data length: 7.00, total dup: 64, max dup: 13
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 20
Index POS06NAMA1 (3)
Depth: 2, leaf buckets: 21, nodes: 1466
Average data length: 7.00, total dup: 65, max dup: 13
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 20
POS07 (193)
Primary pointer page: 1042, Index root page: 1043
Data pages: 303, data page slots: 303, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 173
80 - 99% = 129
Index POS071 (0)
Depth: 2, leaf buckets: 10, nodes: 1300
Average data length: 1.00, total dup: 1, max dup: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 10
Index POS07NAMA (1)
Depth: 2, leaf buckets: 20, nodes: 1300
Average data length: 8.00, total dup: 60, max dup: 10
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 20
Index POS07NAMA1 (2)
Depth: 2, leaf buckets: 20, nodes: 1300
Average data length: 8.00, total dup: 60, max dup: 10
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 20
POS08 (194)
Primary pointer page: 1044, Index root page: 1045
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index POS08NAMA (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index POS08NAMA1 (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
POS10 (195)
Primary pointer page: 1047, Index root page: 1048
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index POS10NAMA (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PO_DTL (196)
Primary pointer page: 1049, Index root page: 1050
Data pages: 2, data page slots: 2, average fill: 47%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
Index RDB$FOREIGN27 (0)
Depth: 1, leaf buckets: 1, nodes: 15
Average data length: 4.00, total dup: 9, max dup: 5
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PO_HDR (197)
Primary pointer page: 1051, Index root page: 1052
Data pages: 1, data page slots: 1, average fill: 51%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY15 (0)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 11.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PRTKITCHEN (228)
Primary pointer page: 1116, Index root page: 1117
Data pages: 99, data page slots: 99, average fill: 73%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 98
80 - 99% = 0
PR_DTL (198)
Primary pointer page: 1053, Index root page: 1054
Data pages: 1, data page slots: 1, average fill: 31%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$FOREIGN28 (0)
Depth: 1, leaf buckets: 1, nodes: 5
Average data length: 7.00, total dup: 2, max dup: 2
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PR_HDR (199)
Primary pointer page: 1055, Index root page: 1056
Data pages: 1, data page slots: 1, average fill: 18%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY16 (0)
Depth: 1, leaf buckets: 1, nodes: 3
Average data length: 12.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RC_DTL (200)
Primary pointer page: 1057, Index root page: 1058
Data pages: 2, data page slots: 2, average fill: 57%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1
80 - 99% = 0
Index RDB$FOREIGN29 (0)
Depth: 1, leaf buckets: 1, nodes: 16
Average data length: 3.00, total dup: 11, max dup: 5
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RC_HDR (201)
Primary pointer page: 1059, Index root page: 1060
Data pages: 1, data page slots: 1, average fill: 35%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY17 (0)
Depth: 1, leaf buckets: 1, nodes: 5
Average data length: 11.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
REVENUE (202)
Primary pointer page: 1061, Index root page: 1062
Data pages: 1, data page slots: 1, average fill: 28%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RPTHDR (203)
Primary pointer page: 1063, Index root page: 1064
Data pages: 1, data page slots: 1, average fill: 6%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SALES (204)
Primary pointer page: 1066, Index root page: 1067
Data pages: 4, data page slots: 4, average fill: 67%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0
Index SALES1 (0)
Depth: 1, leaf buckets: 1, nodes: 44
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SALESITEM (205)
Primary pointer page: 1068, Index root page: 1069
Data pages: 1, data page slots: 1, average fill: 74%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
SCHPOINT (206)
Primary pointer page: 1070, Index root page: 1071
Data pages: 1, data page slots: 1, average fill: 28%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SECURITY (207)
Primary pointer page: 1072, Index root page: 1073
Data pages: 28, data page slots: 28, average fill: 93%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 27
Index SECURITY1 (0)
Depth: 2, leaf buckets: 4, nodes: 371
Average data length: 3.00, total dup: 8, max dup: 2
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 3
SLSEMPLOYEE (208)
Primary pointer page: 1074, Index root page: 1075
Data pages: 1, data page slots: 1, average fill: 9%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SOAPISSUES (209)
Primary pointer page: 1076, Index root page: 1077
Data pages: 1, data page slots: 1, average fill: 14%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY18 (0)
Depth: 1, leaf buckets: 1, nodes: 3
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SOAPRESOLUTION (210)
Primary pointer page: 1078, Index root page: 1079
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
STROOKE (211)
Primary pointer page: 1080, Index root page: 1081
Data pages: 11, data page slots: 11, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1
80 - 99% = 9
Index RDB$PRIMARY19 (0)
Depth: 1, leaf buckets: 1, nodes: 41
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SUBDEPT (212)
Primary pointer page: 1082, Index root page: 1083
Data pages: 8, data page slots: 8, average fill: 71%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 7
80 - 99% = 0
Index RDB$PRIMARY20 (0)
Depth: 1, leaf buckets: 1, nodes: 85
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
SUMBILL (213)
Primary pointer page: 1085, Index root page: 1086
Data pages: 2, data page slots: 2, average fill: 58%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1
80 - 99% = 0
Index SUMBILL1 (0)
Depth: 1, leaf buckets: 1, nodes: 12
Average data length: 4.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SUMMARY (214)
Primary pointer page: 1087, Index root page: 1088
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SUMPAY (215)
Primary pointer page: 1089, Index root page: 1090
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SUPPLIER (216)
Primary pointer page: 1091, Index root page: 1092
Data pages: 1, data page slots: 1, average fill: 14%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY21 (0)
Depth: 1, leaf buckets: 1, nodes: 2
Average data length: 2.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TABEL (217)
Primary pointer page: 1093, Index root page: 1094
Data pages: 1, data page slots: 1, average fill: 55%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
TGLRP (218)
Primary pointer page: 1095, Index root page: 1096
Data pages: 1, data page slots: 1, average fill: 40%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TODAYEVENT (219)
Primary pointer page: 1097, Index root page: 1098
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TR_DTL (220)
Primary pointer page: 1099, Index root page: 1100
Data pages: 1, data page slots: 1, average fill: 30%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$FOREIGN30 (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 9.00, total dup: 2, max dup: 2
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TR_HDR (221)
Primary pointer page: 1101, Index root page: 1102
Data pages: 1, data page slots: 1, average fill: 9%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY22 (0)
Depth: 1, leaf buckets: 1, nodes: 2
Average data length: 19.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TSGROUP (222)
Primary pointer page: 1104, Index root page: 1105
Data pages: 1, data page slots: 1, average fill: 17%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TSMENU (223)
Primary pointer page: 1106, Index root page: 1107
Data pages: 382, data page slots: 382, average fill: 75%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 381
80 - 99% = 0
TSMENUX (224)
Primary pointer page: 1108, Index root page: 1109
Data pages: 60, data page slots: 60, average fill: 74%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 59
80 - 99% = 0
URUT (225)
Primary pointer page: 1110, Index root page: 1111
Data pages: 1, data page slots: 1, average fill: 16%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY23 (0)
Depth: 1, leaf buckets: 1, nodes: 6
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
WAITER (226)
Primary pointer page: 1112, Index root page: 1113
Data pages: 33, data page slots: 33, average fill: 74%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 33
80 - 99% = 0
Index RDB$PRIMARY24 (0)
Depth: 2, leaf buckets: 4, nodes: 356
Average data length: 2.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 3
Service ended at 24/04/2009 7:29:37
----------
SET SQL DIALECT 3;
/* CREATE DATABASE 'C:\data\MYXPOSSDB.GDB' PAGE_SIZE 1024
DEFAULT CHARACTER SET NONE */
/* Table: ACCESMENU, Owner: SYSDBA */
CREATE TABLE "ACCESMENU"
(
"USERID" VARCHAR(10) NOT NULL,
"M_NAMA" VARCHAR(30) NOT NULL,
"M_ACTION" INTEGER DEFAULT 0,
"M_LEVEL" INTEGER,
"M_BMP" INTEGER
);
/* Table: ACCESUSER, Owner: SYSDBA */
CREATE TABLE "ACCESUSER"
(
"USERID" VARCHAR(10) NOT NULL,
"MAIN1" VARCHAR(1),
"MAIN2" VARCHAR(1),
"MAIN3" VARCHAR(1),
"MAIN4" VARCHAR(1),
"MAIN5" VARCHAR(1),
"MAIN6" VARCHAR(1),
"MAIN7" VARCHAR(1),
"MAIN8" VARCHAR(1),
"MAIN9" VARCHAR(1),
"MAIN10" VARCHAR(1),
"MAIN11" VARCHAR(1),
"MAIN12" VARCHAR(1),
"MAIN13" VARCHAR(1),
"MAIN14" VARCHAR(1),
"MAIN15" VARCHAR(1),
"MAIN16" VARCHAR(1),
"MAIN17" VARCHAR(1),
"MAIN18" VARCHAR(1),
"MAIN19" VARCHAR(1),
"MAIN20" VARCHAR(1),
"MAIN21" VARCHAR(1),
"MAIN22" VARCHAR(1),
"MAIN23" VARCHAR(1),
"MAIN24" VARCHAR(1),
"MAIN25" VARCHAR(1),
"MAIN26" VARCHAR(1),
"MAIN27" VARCHAR(1),
"MAIN28" VARCHAR(1),
"MAIN29" VARCHAR(1),
"MAIN30" VARCHAR(1),
"MAIN31" VARCHAR(1),
"MAIN32" VARCHAR(1),
"MAIN33" VARCHAR(1),
"MAIN34" VARCHAR(1),
"MAIN35" VARCHAR(1),
"MAIN36" VARCHAR(1),
"MAIN37" VARCHAR(1),
"MAIN38" VARCHAR(1),
"MAIN39" VARCHAR(1),
"MAIN40" VARCHAR(1),
"MAIN41" VARCHAR(1),
"MAIN42" VARCHAR(1),
"MAIN43" VARCHAR(1),
"MAIN44" VARCHAR(1),
"MAIN45" VARCHAR(1),
"MAIN46" VARCHAR(1),
"MAIN47" VARCHAR(1),
"MAIN48" VARCHAR(1),
"MAIN49" VARCHAR(1),
"MAIN50" VARCHAR(1),
"MAIN51" VARCHAR(1),
"MAIN52" VARCHAR(1),
"MAIN53" VARCHAR(1),
"MAIN54" VARCHAR(1),
"MAIN55" VARCHAR(1),
"MAIN56" VARCHAR(1),
"MAIN57" VARCHAR(1),
"MAIN58" VARCHAR(1),
"MAIN59" VARCHAR(1),
"MAIN60" VARCHAR(1),
"MAIN61" VARCHAR(1),
"MAIN62" VARCHAR(1),
"MAIN63" VARCHAR(1),
"MAIN64" VARCHAR(1),
"MAIN65" VARCHAR(1),
"MAIN66" VARCHAR(1),
"MAIN67" VARCHAR(1),
"MAIN68" VARCHAR(1),
"MAIN69" VARCHAR(1),
"MAIN70" VARCHAR(1),
"MAIN71" VARCHAR(1),
"MAIN72" VARCHAR(1),
"MAIN73" VARCHAR(1),
"MAIN74" VARCHAR(1),
"MAIN75" VARCHAR(1),
"MAIN76" VARCHAR(1),
"MAIN77" VARCHAR(1),
"MAIN78" VARCHAR(1),
"MAIN79" VARCHAR(1),
"MAIN80" VARCHAR(1),
"MAIN81" VARCHAR(1),
"MAIN82" VARCHAR(1),
"MAIN83" VARCHAR(1),
"MAIN84" VARCHAR(1),
"MAIN85" VARCHAR(1),
"MAIN86" VARCHAR(1),
"MAIN87" VARCHAR(1),
"MAIN88" VARCHAR(1),
"MAIN89" VARCHAR(1),
"MAIN90" VARCHAR(1),
"MAIN91" VARCHAR(1),
"MAIN92" VARCHAR(1),
"MAIN93" VARCHAR(1),
"MAIN94" VARCHAR(1),
"MAIN95" VARCHAR(1),
"MAIN96" VARCHAR(1),
"MAIN97" VARCHAR(1),
"MAIN98" VARCHAR(1),
"MAIN99" VARCHAR(1),
"MAIN100" VARCHAR(1),
"MAIN101" VARCHAR(1),
"MAIN102" VARCHAR(1),
"MAIN103" VARCHAR(1),
"MAIN104" VARCHAR(1),
"MAIN105" VARCHAR(1),
"MAIN106" VARCHAR(1),
"MAIN107" VARCHAR(1),
"MAIN108" VARCHAR(1),
"MAIN109" VARCHAR(1),
"MAIN110" VARCHAR(1),
"MAIN111" VARCHAR(1),
"MAIN112" VARCHAR(1),
"MAIN113" VARCHAR(1),
"MAIN114" VARCHAR(1),
"MAIN115" VARCHAR(1),
"MAIN116" VARCHAR(1),
"MAIN117" VARCHAR(1),
"MAIN118" VARCHAR(1),
"MAIN119" VARCHAR(1),
"MAIN120" VARCHAR(1),
"MAIN121" VARCHAR(1),
"MAIN122" VARCHAR(1),
"MAIN123" VARCHAR(1),
"MAIN124" VARCHAR(1),
"MAIN125" VARCHAR(1),
"MAIN126" VARCHAR(1),
"MAIN127" VARCHAR(1),
"MAIN128" VARCHAR(1),
"MAIN129" VARCHAR(1),
"MAIN130" VARCHAR(1),
"MAIN131" VARCHAR(1),
"MAIN132" VARCHAR(1),
"MAIN133" VARCHAR(1),
"MAIN134" VARCHAR(1),
"MAIN135" VARCHAR(1),
"MAIN136" VARCHAR(1),
"MAIN137" VARCHAR(1),
"MAIN138" VARCHAR(1),
"MAIN139" VARCHAR(1),
"MAIN140" VARCHAR(1),
"MAIN141" VARCHAR(1),
"MAIN142" VARCHAR(1),
"MAIN143" VARCHAR(1),
"MAIN144" VARCHAR(1),
"MAIN145" VARCHAR(1),
"MAIN146" VARCHAR(1),
"MAIN147" VARCHAR(1),
"MAIN148" VARCHAR(1),
"MAIN149" VARCHAR(1),
"MAIN150" VARCHAR(1),
"MAIN151" VARCHAR(1),
"MAIN152" VARCHAR(1),
"MAIN153" VARCHAR(1),
"MAIN154" VARCHAR(1),
"MAIN155" VARCHAR(1),
"MAIN156" VARCHAR(1),
"MAIN157" VARCHAR(1),
"MAIN158" VARCHAR(1),
"MAIN159" VARCHAR(1),
"MAIN160" VARCHAR(1),
"MAIN161" VARCHAR(1),
"MAIN162" VARCHAR(1),
"MAIN163" VARCHAR(1),
"MAIN164" VARCHAR(1),
"MAIN165" VARCHAR(1),
"MAIN166" VARCHAR(1),
"MAIN167" VARCHAR(1),
"MAIN168" VARCHAR(1),
"MAIN169" VARCHAR(1),
"MAIN170" VARCHAR(1),
"MAIN171" VARCHAR(1),
"MAIN172" VARCHAR(1),
"MAIN173" VARCHAR(1),
"MAIN174" VARCHAR(1),
PRIMARY KEY ("USERID")
);
/* Table: BILLSUM, Owner: SYSDBA */
CREATE TABLE "BILLSUM"
(
"P_LOK" VARCHAR(2),
"P_TGL" DATE,
"P_BON" VARCHAR(6),
"P_MEJA" VARCHAR(4),
"CASHIER" VARCHAR(10),
"TIPE" VARCHAR(10),
"CASH" DOUBLE PRECISION DEFAULT 0,
"CARD1" DOUBLE PRECISION DEFAULT 0,
"SIGNBILL" DOUBLE PRECISION DEFAULT 0,
"VOUCHER" DOUBLE PRECISION DEFAULT 0,
"DEPOSIT" DOUBLE PRECISION DEFAULT 0,
"POINT" INTEGER DEFAULT 0,
"PAX" INTEGER DEFAULT 0
);
/* Table: COMPANION, Owner: SYSDBA */
CREATE TABLE "COMPANION"
(
"C_KODE" VARCHAR(5),
"C_NAMA" VARCHAR(30),
"C_ALAMAT" VARCHAR(50),
"C_TELP" VARCHAR(20),
"C_STATUS" VARCHAR(1) DEFAULT '0',
"C_MAMI" VARCHAR(10)
);
/* Table: CUSTOMER, Owner: SYSDBA */
CREATE TABLE "CUSTOMER"
(
"C_KODE" VARCHAR(5) NOT NULL,
"C_NAMA" VARCHAR(25) DEFAULT ' ',
"C_ALAMAT" VARCHAR(40) DEFAULT ' ',
"C_ALAMAT2" VARCHAR(40) DEFAULT ' ',
"C_KOTA" VARCHAR(20) DEFAULT ' ',
"C_KOTA2" VARCHAR(20) DEFAULT ' ',
"C_TELP" VARCHAR(20) DEFAULT ' ',
"C_TERM" INTEGER DEFAULT 0,
"C_KONTAK" VARCHAR(20) DEFAULT ' ',
"C_NPWP" VARCHAR(20),
"C_LIMIT" DOUBLE PRECISION DEFAULT 0,
"C_KREDIT" DOUBLE PRECISION DEFAULT 0,
"C_USER" VARCHAR(10) DEFAULT ' ',
PRIMARY KEY ("C_KODE")
);
/* Table: DANCER, Owner: SYSDBA */
CREATE TABLE "DANCER"
(
"D_CODE" VARCHAR(5),
"D_NAMA" VARCHAR(30),
"D_ALAMAT" VARCHAR(50),
"D_TELP" VARCHAR(15),
"DEPT1" VARCHAR(3),
"DEPT2" VARCHAR(3),
"DEPT3" VARCHAR(3),
"DEPT4" VARCHAR(3),
"D_ACTIVE" VARCHAR(1) DEFAULT '0',
"D_MAMI" VARCHAR(10)
);
/* Table: DEPT, Owner: SYSDBA */
CREATE TABLE "DEPT"
(
"DIV_CODE" VARCHAR(1),
"DEPT_CODE" VARCHAR(2) NOT NULL,
"DEPT_DESC" VARCHAR(30),
"USERBY" VARCHAR(10) DEFAULT ' ',
PRIMARY KEY ("DEPT_CODE")
);
/* Table: DIV, Owner: SYSDBA */
CREATE TABLE "DIV"
(
"DIV_CODE" VARCHAR(1) NOT NULL,
"DIV_DESC" VARCHAR(30),
"USERBY" VARCHAR(10) DEFAULT ' ',
"D_MIX" VARCHAR(1) DEFAULT ' ',
PRIMARY KEY ("DIV_CODE")
);
/* Table: LOKASI, Owner: SYSDBA */
CREATE TABLE "LOKASI"
(
"LOK_CODE" VARCHAR(2) NOT NULL,
"LOK_DESC" VARCHAR(20),
"L_POS" VARCHAR(5),
"LOK_SEGMEN" INTEGER DEFAULT 0,
"LOK_ZONE" INTEGER DEFAULT 0,
"LOK_NAMA" VARCHAR(20),
"LOK_ALAMAT" VARCHAR(30),
"LOK_AREA" VARCHAR(20),
"LOK_TELP" VARCHAR(15),
"LOK_NPWP" VARCHAR(15),
"USERBY" VARCHAR(10) DEFAULT ' ',
"POS" VARCHAR(1) DEFAULT '0',
"LOKBMP" VARCHAR(50) DEFAULT '',
"TOTAL" VARCHAR(1) DEFAULT '0',
"FACILITY" VARCHAR(1) DEFAULT '0',
PRIMARY KEY ("LOK_CODE")
);
/* Table: MASTPOS, Owner: SYSDBA */
CREATE TABLE "MASTPOS"
(
"M_NOREG" VARCHAR(10) DEFAULT '0',
"M_DIV" VARCHAR(1) DEFAULT ' ',
"M_DEPT" VARCHAR(2) DEFAULT ' ',
"M_SDEPT" VARCHAR(4) DEFAULT ' ',
"M_STOCK" VARCHAR(1) DEFAULT '1',
"M_HEADER" VARCHAR(1) DEFAULT '0',
"M_PKP" VARCHAR(1) DEFAULT '0',
"M_SKU" VARCHAR(8) DEFAULT ' ',
"M_SKU2" VARCHAR(4) DEFAULT ' ',
"M_NAMA" VARCHAR(50) DEFAULT ' ',
"M_NAMAS" VARCHAR(30) DEFAULT ' ',
"M_CRT" INTEGER DEFAULT 1,
"M_BOX" INTEGER DEFAULT 0,
"M_PCS" INTEGER DEFAULT 0,
"M_SIZE" VARCHAR(15) DEFAULT ' ',
"M_DIS" INTEGER DEFAULT 0,
"M_DIS2" INTEGER DEFAULT 0,
"M_KOM" VARCHAR(1) DEFAULT '0',
"M_PPN" INTEGER DEFAULT 0,
"M_SVC" INTEGER DEFAULT 0,
"M_USER" VARCHAR(10) DEFAULT ' ',
"M_BRAND" VARCHAR(4) DEFAULT ' ',
"M_ACTIVE" VARCHAR(1) DEFAULT '0',
"M_SELL1" INTEGER DEFAULT 0,
"M_SELL2" INTEGER DEFAULT 0,
"M_SELL3" INTEGER DEFAULT 0,
"M_MINSTOCK" INTEGER DEFAULT 0,
"M_MAXSTOCK" INTEGER DEFAULT 0,
"M_COST" DOUBLE PRECISION DEFAULT 0,
"M_TGLC" DATE DEFAULT 'NOW',
"M_TGLC2" DATE DEFAULT 'NOW',
"M_TGLC3" DATE DEFAULT 'NOW',
"M_TGLC4" DATE DEFAULT 'NOW'
);
/* Table: MEJA, Owner: SYSDBA */
CREATE TABLE "MEJA"
(
"CODE_MEJA" VARCHAR(5) NOT NULL,
"DESC_MEJA" VARCHAR(30),
"TYPE_MEJA" VARCHAR(1) DEFAULT 0,
"STATUS_MEJA" VARCHAR(1) DEFAULT 0,
"MCHG1_MEJA" INTEGER NOT NULL,
"MCHG2_MEJA" INTEGER NOT NULL,
"M_LOK" VARCHAR(2),
"PAX" INTEGER,
"GUEST" VARCHAR(30),
"JAM_IN" TIME,
"LINE" INTEGER,
"BILL" VARCHAR(1) DEFAULT '0',
"CODE_MEJA2" VARCHAR(5) DEFAULT '',
"USERBY" VARCHAR(10) DEFAULT ' ',
"M_PPN" INTEGER DEFAULT 0,
"M_SVC" INTEGER DEFAULT 0,
"M_PAKET" INTEGER DEFAULT 1,
"TOP" INTEGER DEFAULT 0,
"POSLEFT" INTEGER DEFAULT 0,
"INFO" VARCHAR(1) DEFAULT '0',
"WIDTH" INTEGER DEFAULT 40,
"HEIGHT" INTEGER DEFAULT 40,
"LAYOUT" VARCHAR(1) DEFAULT '0',
"M_JAM1" TIME DEFAULT '13:00:00',
"M_JAM2" TIME DEFAULT '19:59:59',
"M_JAM" TIME DEFAULT 'NOW',
"FACILITY" VARCHAR(1) DEFAULT '0',
"SESSION" VARCHAR(1) DEFAULT '0',
"TMPDAILY" VARCHAR(1),
"DAILY" VARCHAR(1) default '0',
"SESION" INTEGER DEFAULT 1,
PRIMARY KEY ("CODE_MEJA")
);
/* Table: MESS, Owner: SYSDBA */
CREATE TABLE "MESS"
(
"MESS" VARCHAR(30),
"STATUS" VARCHAR(10)
);
/* Table: MIX, Owner: SYSDBA */
CREATE TABLE "MIX"
(
"M_CODE" VARCHAR(1),
"M_DESC" VARCHAR(10)
);
/* Table: MNGMENU, Owner: SYSDBA */
CREATE TABLE "MNGMENU"
(
"M_NAMA" VARCHAR(30) NOT NULL,
"M_ACTION" INTEGER,
"M_BMP" INTEGER,
"M_LEVEL" INTEGER,
PRIMARY KEY ("M_NAMA")
);
/* Table: MYCHEF, Owner: SYSDBA */
CREATE TABLE "MYCHEF"
(
"C_KODE" VARCHAR(3) Default '-',
"C_NAMA" VARCHAR(30) default ' ',
"C_ACTIVE" VARCHAR(1) default '0'
);
/* Table: MYKITCHEN, Owner: SYSDBA */
CREATE TABLE "MYKITCHEN"
(
"P_TGL" DATE Default 'now',
"P_LOK" VARCHAR(2) default ' ',
"P_ORD" VARCHAR(6) default ' ',
"P_SKU" VARCHAR(8) default ' ',
"P_QTY" INTEGER default 0,
"P_CHEF" VARCHAR(10) default ' ',
"START1" TIMESTAMP,
"P_START" TIMESTAMP default 'now',
"P_END" TIMESTAMP default 'now',
"P_WAKTU" COMPUTED BY ((p_end-p_start)*(24*3600))
);
/* Table: MYKITCHEN2, Owner: SYSDBA */
CREATE TABLE "MYKITCHEN2"
(
"P_TGL" DATE Default 'now',
"P_LOK" VARCHAR(2) default ' ',
"P_ORD" VARCHAR(6) default ' ',
"P_SKU" VARCHAR(8) default ' ',
"P_QTY" INTEGER default 0,
"P_CHEF" VARCHAR(10) default ' ',
"P_START" TIME default 'now',
"P_END" TIME default 'now',
"P_WAKTU" COMPUTED BY ((p_end-p_start)*(24*3600))
);
/* Table: MYOR, Owner: SYSDBA */
CREATE TABLE "MYOR"
(
"O_TGL" DATE,
"O_NOMOR" VARCHAR(6),
"O_NOREG" VARCHAR(4),
"O_PELAY" VARCHAR(10),
"O_JAM1" INTEGER,
"O_JAM2" INTEGER,
"O_MEM" VARCHAR(30),
"O_PAX" INTEGER DEFAULT 0,
"O_MEJA" VARCHAR(4),
"O_JAMT1" INTEGER DEFAULT 0,
"O_JAMT2" INTEGER DEFAULT 0,
"O_USER" VARCHAR(10),
"O_FLAG2" VARCHAR(1),
"O_BON" VARCHAR(7),
"O_TELP" VARCHAR(15),
"O_JAMIN" TIME,
"O_FLAG" VARCHAR(1) DEFAULT ' ',
"O_JAMOUT" TIME,
"O_MEJA2" VARCHAR(5) DEFAULT ' ',
"O_LOK" VARCHAR(2) DEFAULT '00',
"O_JAMPKT" INTEGER DEFAULT '0',
"O_TIMEOUT" TIME DEFAULT '00:00:00',
"P_EOD" VARCHAR(1) DEFAULT '0',
"WAKTU" INTEGER DEFAULT 0,
"O_DATEIN" DATE DEFAULT 'NOW',
"O_DATEOUT" DATE DEFAULT 'NOW',
"ADDRESS" VARCHAR(50) DEFAULT ' ',
"NATIONALITY" VARCHAR(20) DEFAULT ' ',
"TEMPAT" VARCHAR(30) DEFAULT ' ',
"TGLLHR" DATE DEFAULT 'NOW',
"IDNO" VARCHAR(20) DEFAULT ' ',
"PHONE" VARCHAR(30) DEFAULT ' ',
"DEPOSIT" DOUBLE PRECISION DEFAULT 0,
"CARDDEPOSIT" DOUBLE PRECISION DEFAULT 0,
"NOCARD" VARCHAR(16) DEFAULT ' ',
"NAMECARD" VARCHAR(30) DEFAULT ' ',
"VOUCHER" DOUBLE PRECISION DEFAULT 0,
"O_TGLCO" DATE,
"O_ENT" VARCHAR(1) DEFAULT '0'
);
/* Table: MYSS, Owner: SYSDBA */
CREATE TABLE "MYSS"
(
"P_TGL" DATE,
"P_PDMEJ" VARCHAR(4) DEFAULT ' ',
"P_PDOLE" VARCHAR(10) DEFAULT ' ',
"P_PDJAM" VARCHAR(8) DEFAULT ' ',
"P_LOK" VARCHAR(2) DEFAULT ' ',
"P_BAR" VARCHAR(2) DEFAULT ' ',
"P_TERM" VARCHAR(2) DEFAULT ' ',
"P_MEJA" VARCHAR(4) DEFAULT ' ',
"P_ORD" VARCHAR(6) DEFAULT ' ',
"P_BON" VARCHAR(7) DEFAULT ' ',
"P_MEMBER" VARCHAR(6) DEFAULT ' ',
"P_NRP" VARCHAR(10) DEFAULT ' ',
"P_PELAY" VARCHAR(10) DEFAULT ' ',
"P_SIF" VARCHAR(1) DEFAULT ' ',
"P_SKU" VARCHAR(8) DEFAULT ' ',
"P_QTY" INTEGER DEFAULT 0,
"P_SEL2" DOUBLE PRECISION DEFAULT 0,
"P_SEL" DOUBLE PRECISION DEFAULT 0,
"P_DIS" INTEGER DEFAULT 0,
"P_DIS1" INTEGER DEFAULT 0,
"P_END" VARCHAR(10) DEFAULT ' ',
"P_PAX" INTEGER DEFAULT 0,
"P_PPN" INTEGER DEFAULT 0,
"P_SVC" INTEGER DEFAULT 0,
"P_TERIMA" VARCHAR(1) DEFAULT ' ',
"P_CETAK" VARCHAR(1) DEFAULT ' ',
"P_PEND" VARCHAR(10) DEFAULT ' ',
"P_JAM" TIME,
"P_FLAG" VARCHAR(1) DEFAULT ' ',
"SDEPT_CODE" VARCHAR(3) DEFAULT ' ',
"P_PISAH" INTEGER DEFAULT 0,
"P_EOD" VARCHAR(1) DEFAULT '0',
"P_CDIS" VARCHAR(1) DEFAULT ' ',
"P_PKP" VARCHAR(1) DEFAULT '0',
"STATUS" INTEGER DEFAULT 0,
"P_CHGDIS" VARCHAR(1) DEFAULT '0',
"INFO" VARCHAR(30) DEFAULT '',
"PRINTTO" VARCHAR(20) DEFAULT '',
"P_USER2" VARCHAR(10) DEFAULT '',
"P_CO" VARCHAR(1) DEFAULT '0',
"P_TGLCO" DATE,
"P_COMP" VARCHAR(10) DEFAULT '',
"STPRINT" VARCHAR(1) DEFAULT '0',
"P_JAAM" TIME DEFAULT '00:00:00',
"P_KITC" VARCHAR(1) DEFAULT '0'
);
/* Table: MYTERM, Owner: SYSDBA */
CREATE TABLE "MYTERM"
(
"P_TERM" VARCHAR(2),
"P_LOK" VARCHAR(2),
"P_PRINT" VARCHAR(40)
);
/* Table: MYUPDATE, Owner: SYSDBA */
CREATE TABLE "MYUPDATE"
(
"FRESH" VARCHAR(1)
);
/* Table: MYURUT, Owner: SYSDBA */
CREATE TABLE "MYURUT"
(
"LOK" VARCHAR(3) DEFAULT ' ',
"NO_ORDER" INTEGER DEFAULT 0,
"NO_BILL" INTEGER DEFAULT 0,
"PO" INTEGER DEFAULT 0,
"RC" INTEGER DEFAULT 0,
"PR" INTEGER DEFAULT 0,
"BT" INTEGER DEFAULT 0,
"SR" INTEGER DEFAULT 0,
"REG" INTEGER DEFAULT 0,
"RES" INTEGER DEFAULT 0
);
/* Table: MYXX, Owner: SYSDBA */
CREATE TABLE "MYXX"
(
"TGL" DATE DEFAULT 'now',
"LOK" VARCHAR(2) DEFAULT '',
"MEJAFROM" VARCHAR(4) DEFAULT '',
"MEJATO" VARCHAR(4) DEFAULT '',
"SKU" VARCHAR(8) DEFAULT '',
"QTY" INTEGER DEFAULT 0,
"ORD" VARCHAR(6) DEFAULT '',
"TERM" VARCHAR(2),
"USERBY" VARCHAR(10),
"APP" VARCHAR(10),
"WAKTU" TIME
);
/* Table: POINT, Owner: SYSDBA */
CREATE TABLE "POINT"
(
"TGL" DATE DEFAULT 'NOW',
"CARD" VARCHAR(16) DEFAULT '',
"UANG" DOUBLE PRECISION DEFAULT 0,
"PERSENT" INTEGER DEFAULT 0,
"POINT" INTEGER DEFAULT 0,
"SISA" DOUBLE PRECISION
);
/* Table: POS01, Owner: SYSDBA */
CREATE TABLE "POS01"
(
"M_GROUP" VARCHAR(4) DEFAULT ' ',
"M_SKU" VARCHAR(8) DEFAULT ' ',
"M_SKU2" VARCHAR(4) DEFAULT ' ',
"M_NAMA" VARCHAR(21) DEFAULT ' ',
"M_NAMAS" VARCHAR(21) DEFAULT ' ',
"M_BOX" INTEGER DEFAULT 0,
"M_PCS" INTEGER DEFAULT 0,
"M_SIZE" VARCHAR(8) DEFAULT ' ',
"M_DIS" INTEGER DEFAULT 0,
"M_DIS2" INTEGER DEFAULT 0,
"M_SELL1" INTEGER DEFAULT 0,
"M_SELL2" INTEGER DEFAULT 0,
"M_SELL3" INTEGER DEFAULT 0,
"M_KOM" VARCHAR(1) DEFAULT ' ',
"M_MEMBER" VARCHAR(1) DEFAULT ' ',
"M_DIS3" INTEGER DEFAULT 0,
"M_MIX" VARCHAR(1) DEFAULT ' ',
"M_TOMIX" VARCHAR(1) DEFAULT ' ',
"M_PPN" INTEGER DEFAULT 0,
"M_SVC" INTEGER DEFAULT 0,
"PRINT" VARCHAR(30) DEFAULT 'LPT1',
"M_PKP" VARCHAR(1) DEFAULT '0',
"M_CHANGE" VARCHAR(1) DEFAULT '0',
"M_JAM1" TIME DEFAULT '00:00:00',
"M_JAM2" TIME DEFAULT '23:59:59',
"M_JAM3" TIME DEFAULT '00:00:00',
"M_JAM4" TIME DEFAULT '23:59:59',
"M_CRT" INTEGER DEFAULT 0,
"M_USER" VARCHAR(10) DEFAULT ' ',
"M_BRAND" VARCHAR(4) DEFAULT ' ',
"M_HEADER" VARCHAR(1) DEFAULT '0',
"SDEPT" VARCHAR(4),
"STDISC" VARCHAR(1) DEFAULT '0',
"VDISCMEMBER" INTEGER DEFAULT 0,
"MEMBER" VARCHAR(1) DEFAULT '0'
);
/* Table: POS02, Owner: SYSDBA */
CREATE TABLE "POS02"
(
"M_GROUP" VARCHAR(4) DEFAULT ' ',
"M_SKU" VARCHAR(8) DEFAULT ' ',
"M_SKU2" VARCHAR(4) DEFAULT ' ',
"M_NAMA" VARCHAR(21) DEFAULT ' ',
"M_NAMAS" VARCHAR(21) DEFAULT ' ',
"M_BOX" INTEGER DEFAULT 0,
"M_PCS" INTEGER DEFAULT 0,
"M_SIZE" VARCHAR(8) DEFAULT ' ',
"M_DIS" INTEGER DEFAULT 0,
"M_DIS2" INTEGER DEFAULT 0,
"M_SELL1" INTEGER DEFAULT 0,
"M_SELL2" INTEGER DEFAULT 0,
"M_SELL3" INTEGER DEFAULT 0,
"M_KOM" VARCHAR(1) DEFAULT ' ',
"M_MEMBER" VARCHAR(1) DEFAULT ' ',
"M_DIS3" INTEGER DEFAULT 0,
"M_MIX" VARCHAR(1) DEFAULT ' ',
"M_TOMIX" VARCHAR(1) DEFAULT ' ',
"M_PPN" INTEGER DEFAULT 0,
"M_SVC" INTEGER DEFAULT 0,
"PRINT" VARCHAR(30) DEFAULT 'LPT1',
"M_PKP" VARCHAR(1) DEFAULT '0',
"M_CHANGE" VARCHAR(1) DEFAULT '0',
"M_JAM1" TIME DEFAULT '00:00:00',
"M_JAM2" TIME DEFAULT '23:59:59',
"M_JAM3" TIME DEFAULT '00:00:00',
"M_JAM4" TIME DEFAULT '23:59:59',
"M_CRT" INTEGER DEFAULT 0,
"M_USER" VARCHAR(10) DEFAULT ' ',
"M_BRAND" VARCHAR(4) DEFAULT ' ',
"M_HEADER" VARCHAR(1) DEFAULT '0',
"SDEPT" VARCHAR(4),
"STDISC" VARCHAR(1) DEFAULT '0',
"VDISCMEMBER" INTEGER DEFAULT 0,
"MEMBER" VARCHAR(1) DEFAULT '0'
);
/* Table: POS03, Owner: SYSDBA */
CREATE TABLE "POS03"
(
"M_GROUP" VARCHAR(4) DEFAULT ' ',
"M_SKU" VARCHAR(8) DEFAULT ' ',
"M_SKU2" VARCHAR(4) DEFAULT ' ',
"M_NAMA" VARCHAR(21) DEFAULT ' ',
"M_NAMAS" VARCHAR(21) DEFAULT ' ',
"M_BOX" INTEGER DEFAULT 0,
"M_PCS" INTEGER DEFAULT 0,
"M_SIZE" VARCHAR(8) DEFAULT ' ',
"M_DIS" INTEGER DEFAULT 0,
"M_DIS2" INTEGER DEFAULT 0,
"M_SELL1" INTEGER DEFAULT 0,
"M_SELL2" INTEGER DEFAULT 0,
"M_SELL3" INTEGER DEFAULT 0,
"M_KOM" VARCHAR(1) DEFAULT ' ',
"M_MEMBER" VARCHAR(1) DEFAULT ' ',
"M_DIS3" INTEGER DEFAULT 0,
"M_MIX" VARCHAR(1) DEFAULT ' ',
"M_TOMIX" VARCHAR(1) DEFAULT ' ',
"M_PPN" INTEGER DEFAULT 0,
"M_SVC" INTEGER DEFAULT 0,
"PRINT" VARCHAR(30) DEFAULT 'LPT1',
"M_PKP" VARCHAR(1) DEFAULT '0',
"M_CHANGE" VARCHAR(1) DEFAULT '0',
"M_JAM1" TIME DEFAULT '00:00:00',
"M_JAM2" TIME DEFAULT '23:59:59',
"M_JAM3" TIME DEFAULT '00:00:00',
"M_JAM4" TIME DEFAULT '23:59:59',
"M_CRT" INTEGER DEFAULT 0,
"M_USER" VARCHAR(10) DEFAULT ' ',
"M_BRAND" VARCHAR(4) DEFAULT ' ',
"M_HEADER" VARCHAR(1) DEFAULT '0',
"SDEPT" VARCHAR(4),
"STDISC" VARCHAR(1) DEFAULT '0',
"VDISCMEMBER" INTEGER DEFAULT 0,
"MEMBER" VARCHAR(1) DEFAULT '0'
);
/* Table: POS05, Owner: SYSDBA */
CREATE TABLE "POS05"
(
"M_GROUP" VARCHAR(4) DEFAULT ' ',
"M_SKU" VARCHAR(8) DEFAULT ' ',
"M_SKU2" VARCHAR(4) DEFAULT ' ',
"M_NAMA" VARCHAR(21) DEFAULT ' ',
"M_NAMAS" VARCHAR(21) DEFAULT ' ',
"M_BOX" INTEGER DEFAULT 0,
"M_PCS" INTEGER DEFAULT 0,
"M_SIZE" VARCHAR(8) DEFAULT ' ',
"M_DIS" INTEGER DEFAULT 0,
"M_DIS2" INTEGER DEFAULT 0,
"M_SELL1" INTEGER DEFAULT 0,
"M_SELL2" INTEGER DEFAULT 0,
"M_SELL3" INTEGER DEFAULT 0,
"M_KOM" VARCHAR(1) DEFAULT ' ',
"M_MEMBER" VARCHAR(1) DEFAULT ' ',
"M_DIS3" INTEGER DEFAULT 0,
"M_MIX" VARCHAR(1) DEFAULT ' ',
"M_TOMIX" VARCHAR(1) DEFAULT ' ',
"M_PPN" INTEGER DEFAULT 0,
"M_SVC" INTEGER DEFAULT 0,
"PRINT" VARCHAR(30) DEFAULT 'LPT1',
"M_PKP" VARCHAR(1) DEFAULT '0',
"M_CHANGE" VARCHAR(1) DEFAULT '0',
"M_JAM1" TIME DEFAULT '00:00:00',
"M_JAM2" TIME DEFAULT '23:59:59',
"M_JAM3" TIME DEFAULT '00:00:00',
"M_JAM4" TIME DEFAULT '23:59:59',
"M_CRT" INTEGER DEFAULT 0,
"M_USER" VARCHAR(10) DEFAULT ' ',
"M_BRAND" VARCHAR(4) DEFAULT ' ',
"M_HEADER" VARCHAR(1) DEFAULT '0',
"SDEPT" VARCHAR(4),
"STDISC" VARCHAR(1) DEFAULT '0',
"VDISCMEMBER" INTEGER DEFAULT 0,
"MEMBER" VARCHAR(1) DEFAULT '0'
);
/* Table: POS06, Owner: SYSDBA */
CREATE TABLE "POS06"
(
"M_GROUP" VARCHAR(4) DEFAULT ' ',
"M_SKU" VARCHAR(8) DEFAULT ' ',
"M_SKU2" VARCHAR(4) DEFAULT ' ',
"M_NAMA" VARCHAR(21) DEFAULT ' ',
"M_NAMAS" VARCHAR(21) DEFAULT ' ',
"M_BOX" INTEGER DEFAULT 0,
"M_PCS" INTEGER DEFAULT 0,
"M_SIZE" VARCHAR(8) DEFAULT ' ',
"M_DIS" INTEGER DEFAULT 0,
"M_DIS2" INTEGER DEFAULT 0,
"M_SELL1" INTEGER DEFAULT 0,
"M_SELL2" INTEGER DEFAULT 0,
"M_SELL3" INTEGER DEFAULT 0,
"M_KOM" VARCHAR(1) DEFAULT ' ',
"M_MEMBER" VARCHAR(1) DEFAULT ' ',
"M_DIS3" INTEGER DEFAULT 0,
"M_MIX" VARCHAR(1) DEFAULT ' ',
"M_TOMIX" VARCHAR(1) DEFAULT ' ',
"M_PPN" INTEG<br/><br/>(Message over 64 KB, truncated)