API tools faq
paste
jabounet

Untitled

jabounet
Jan 17th, 2020
180
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 65.22 KB | None | 0 0
raw download clone embed print report
  1. gstat of not working database :
  2. [code]
  3.  
  4. Database "C:\JSW\JDBBUG.FDB"
  5. Gstat execution time Fri Jan 17 13:15:00 2020
  6.  
  7.  
  8. Database header page information:
  9. Flags 0
  10. Generation 7196
  11. System Change Number 0
  12. Page size 4096
  13. ODS version 12.0
  14. Oldest transaction 6656
  15. Oldest active 6657
  16. Oldest snapshot 76
  17. Next transaction 7188
  18. Sequence number 0
  19. Next attachment ID 424
  20. Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
  21. Shadow count 0
  22. Page buffers 0
  23. Next header page 0
  24. Database dialect 3
  25. Creation date Jan 11, 2020 8:34:10
  26. Attributes force write
  27.  
  28.  
  29. Variable header data:
  30. Sweep interval: 1000
  31. *END*
  32.  
  33.  
  34.  
  35.  
  36. Database file sequence:
  37. File C:\JSW\JDBBUG.FDB is the only file
  38.  
  39.  
  40. Analyzing database pages ...
  41. ACTES (134)
  42. Primary pointer page: 264, Index root page: 265
  43. Pointer pages: 4, data page slots: 3024
  44. Data pages: 3024, average fill: 86%
  45. Primary pages: 3024, secondary pages: 0, swept pages: 3008
  46. Empty pages: 0, full pages: 3023
  47. Fill distribution:
  48. 0 - 19% = 1
  49. 20 - 39% = 0
  50. 40 - 59% = 0
  51. 60 - 79% = 0
  52. 80 - 99% = 3023
  53.  
  54.  
  55. Index FK_ACTES_1 (2)
  56. Root page: 18486, depth: 2, leaf buckets: 74, nodes: 62838
  57. Average node length: 4.70, total dup: 35764, max dup: 20
  58. Average key length: 2.45, compression ratio: 1.41
  59. Average prefix length: 3.02, average data length: 0.44
  60. Clustering factor: 8500, ratio: 0.14
  61. Fill distribution:
  62. 0 - 19% = 0
  63. 20 - 39% = 0
  64. 40 - 59% = 0
  65. 60 - 79% = 1
  66. 80 - 99% = 73
  67.  
  68.  
  69. Index IDX_IDENTACTE (1)
  70. Root page: 18063, depth: 2, leaf buckets: 83, nodes: 62838
  71. Average node length: 5.28, total dup: 0, max dup: 0
  72. Average key length: 3.03, compression ratio: 1.22
  73. Average prefix length: 2.67, average data length: 1.02
  74. Clustering factor: 5829, ratio: 0.09
  75. Fill distribution:
  76. 0 - 19% = 0
  77. 20 - 39% = 0
  78. 40 - 59% = 0
  79. 60 - 79% = 1
  80. 80 - 99% = 82
  81.  
  82.  
  83. Index PK_ACTES (0)
  84. Root page: 17979, depth: 2, leaf buckets: 83, nodes: 62838
  85. Average node length: 5.28, total dup: 0, max dup: 0
  86. Average key length: 3.03, compression ratio: 1.22
  87. Average prefix length: 2.67, average data length: 1.02
  88. Clustering factor: 5829, ratio: 0.09
  89. Fill distribution:
  90. 0 - 19% = 0
  91. 20 - 39% = 0
  92. 40 - 59% = 0
  93. 60 - 79% = 1
  94. 80 - 99% = 82
  95.  
  96.  
  97. AGENDA (137)
  98. Primary pointer page: 270, Index root page: 271
  99. Pointer pages: 2, data page slots: 1224
  100. Data pages: 1224, average fill: 87%
  101. Primary pages: 1221, secondary pages: 3, swept pages: 1189
  102. Empty pages: 2, full pages: 1218
  103. Fill distribution:
  104. 0 - 19% = 4
  105. 20 - 39% = 1
  106. 40 - 59% = 1
  107. 60 - 79% = 0
  108. 80 - 99% = 1218
  109.  
  110.  
  111. Index FK_AGENDA_1 (2)
  112. Root page: 18567, depth: 2, leaf buckets: 18, nodes: 23731
  113. Average node length: 2.98, total dup: 23730, max dup: 23730
  114. Average key length: 1.00, compression ratio: 0.00
  115. Average prefix length: 0.00, average data length: 0.00
  116. Clustering factor: 1219, ratio: 0.05
  117. Fill distribution:
  118. 0 - 19% = 0
  119. 20 - 39% = 0
  120. 40 - 59% = 1
  121. 60 - 79% = 0
  122. 80 - 99% = 17
  123.  
  124.  
  125. Index FK_AGENDA_2 (3)
  126. Root page: 18586, depth: 2, leaf buckets: 18, nodes: 23731
  127. Average node length: 2.98, total dup: 23730, max dup: 23730
  128. Average key length: 1.00, compression ratio: 0.00
  129. Average prefix length: 0.00, average data length: 0.00
  130. Clustering factor: 1219, ratio: 0.05
  131. Fill distribution:
  132. 0 - 19% = 0
  133. 20 - 39% = 0
  134. 40 - 59% = 1
  135. 60 - 79% = 0
  136. 80 - 99% = 17
  137.  
  138.  
  139. Index IDX_AGENDA (1)
  140. Root page: 17946, depth: 2, leaf buckets: 25, nodes: 23737
  141. Average node length: 4.06, total dup: 21993, max dup: 36
  142. Average key length: 2.08, compression ratio: 1.92
  143. Average prefix length: 3.92, average data length: 0.08
  144. Clustering factor: 11579, ratio: 0.49
  145. Fill distribution:
  146. 0 - 19% = 0
  147. 20 - 39% = 0
  148. 40 - 59% = 2
  149. 60 - 79% = 0
  150. 80 - 99% = 23
  151.  
  152.  
  153. Index PK_AGENDA (0)
  154. Root page: 17915, depth: 2, leaf buckets: 30, nodes: 23731
  155. Average node length: 5.06, total dup: 0, max dup: 0
  156. Average key length: 3.07, compression ratio: 1.11
  157. Average prefix length: 2.38, average data length: 1.04
  158. Clustering factor: 3484, ratio: 0.15
  159. Fill distribution:
  160. 0 - 19% = 0
  161. 20 - 39% = 0
  162. 40 - 59% = 0
  163. 60 - 79% = 0
  164. 80 - 99% = 30
  165.  
  166.  
  167. ANIMAUX (129)
  168. Primary pointer page: 253, Index root page: 254
  169. Pointer pages: 1, data page slots: 152
  170. Data pages: 152, average fill: 82%
  171. Primary pages: 151, secondary pages: 1, swept pages: 89
  172. Empty pages: 0, full pages: 150
  173. Fill distribution:
  174. 0 - 19% = 0
  175. 20 - 39% = 1
  176. 40 - 59% = 0
  177. 60 - 79% = 19
  178. 80 - 99% = 132
  179.  
  180.  
  181. Index IDX_ANIMAUX1 (2)
  182. Root page: 18328, depth: 2, leaf buckets: 4, nodes: 4722
  183. Average node length: 2.90, total dup: 4715, max dup: 4714
  184. Average key length: 1.01, compression ratio: 0.01
  185. Average prefix length: 0.00, average data length: 0.01
  186. Clustering factor: 158, ratio: 0.03
  187. Fill distribution:
  188. 0 - 19% = 0
  189. 20 - 39% = 1
  190. 40 - 59% = 0
  191. 60 - 79% = 0
  192. 80 - 99% = 3
  193.  
  194.  
  195. Index PK_ANIMAUX (0)
  196. Root page: 18313, depth: 2, leaf buckets: 6, nodes: 4721
  197. Average node length: 4.90, total dup: 0, max dup: 0
  198. Average key length: 3.01, compression ratio: 0.99
  199. Average prefix length: 1.97, average data length: 1.00
  200. Clustering factor: 797, ratio: 0.17
  201. Fill distribution:
  202. 0 - 19% = 0
  203. 20 - 39% = 0
  204. 40 - 59% = 0
  205. 60 - 79% = 1
  206. 80 - 99% = 5
  207.  
  208.  
  209. Index REFCUSTINORDERS (3)
  210. Root page: 18390, depth: 2, leaf buckets: 7, nodes: 4722
  211. Average node length: 4.52, total dup: 1753, max dup: 25
  212. Average key length: 2.63, compression ratio: 1.12
  213. Average prefix length: 2.32, average data length: 0.63
  214. Clustering factor: 2726, ratio: 0.58
  215. Fill distribution:
  216. 0 - 19% = 0
  217. 20 - 39% = 1
  218. 40 - 59% = 2
  219. 60 - 79% = 0
  220. 80 - 99% = 4
  221.  
  222.  
  223. Index UPPERNOMANIMAL (1)
  224. Root page: 18320, depth: 2, leaf buckets: 10, nodes: 4723
  225. Average node length: 5.94, total dup: 2235, max dup: 42
  226. Average key length: 4.05, compression ratio: 1.41
  227. Average prefix length: 4.07, average data length: 1.63
  228. Clustering factor: 4606, ratio: 0.98
  229. Fill distribution:
  230. 0 - 19% = 0
  231. 20 - 39% = 3
  232. 40 - 59% = 0
  233. 60 - 79% = 3
  234. 80 - 99% = 4
  235.  
  236.  
  237. CAISSE (146)
  238. Primary pointer page: 288, Index root page: 289
  239. Pointer pages: 1, data page slots: 24
  240. Data pages: 24, average fill: 63%
  241. Primary pages: 24, secondary pages: 0, swept pages: 20
  242. Empty pages: 3, full pages: 20
  243. Fill distribution:
  244. 0 - 19% = 3
  245. 20 - 39% = 0
  246. 40 - 59% = 1
  247. 60 - 79% = 20
  248. 80 - 99% = 0
  249.  
  250.  
  251. Index PK_CAISSE (0)
  252. Root page: 17669, depth: 2, leaf buckets: 2, nodes: 1017
  253. Average node length: 4.15, total dup: 0, max dup: 0
  254. Average key length: 3.00, compression ratio: 0.96
  255. Average prefix length: 1.89, average data length: 1.00
  256. Clustering factor: 49, ratio: 0.05
  257. Fill distribution:
  258. 0 - 19% = 1
  259. 20 - 39% = 0
  260. 40 - 59% = 0
  261. 60 - 79% = 0
  262. 80 - 99% = 1
  263.  
  264.  
  265. CATALOGUE (140)
  266. Primary pointer page: 276, Index root page: 277
  267. Pointer pages: 4, data page slots: 2752
  268. Data pages: 2752, average fill: 84%
  269. Primary pages: 2752, secondary pages: 0, swept pages: 2745
  270. Empty pages: 7, full pages: 2744
  271. Fill distribution:
  272. 0 - 19% = 7
  273. 20 - 39% = 0
  274. 40 - 59% = 1
  275. 60 - 79% = 1
  276. 80 - 99% = 2743
  277.  
  278.  
  279. Index PK_REFERENCES (0)
  280. Root page: 17755, depth: 2, leaf buckets: 107, nodes: 65876
  281. Average node length: 6.49, total dup: 0, max dup: 0
  282. Average key length: 4.31, compression ratio: 1.42
  283. Average prefix length: 4.36, average data length: 1.75
  284. Clustering factor: 37022, ratio: 0.56
  285. Fill distribution:
  286. 0 - 19% = 0
  287. 20 - 39% = 0
  288. 40 - 59% = 0
  289. 60 - 79% = 0
  290. 80 - 99% = 107
  291.  
  292.  
  293. CLIENTS (128)
  294. Primary pointer page: 251, Index root page: 252
  295. Pointer pages: 28, data page slots: 22320
  296. Data pages: 22320, average fill: 83%
  297. Primary pages: 152, secondary pages: 22168, swept pages: 0
  298. Empty pages: 4, full pages: 22314
  299. Fill distribution:
  300. 0 - 19% = 5
  301. 20 - 39% = 0
  302. 40 - 59% = 1
  303. 60 - 79% = 11491
  304. 80 - 99% = 10823
  305.  
  306.  
  307. Index CLIENTS_PRIMARY (0)
  308. Root page: 18333, depth: 2, leaf buckets: 4, nodes: 3027
  309. Average node length: 4.90, total dup: 0, max dup: 0
  310. Average key length: 3.00, compression ratio: 0.98
  311. Average prefix length: 1.96, average data length: 1.00
  312. Clustering factor: 1134, ratio: 0.37
  313. Fill distribution:
  314. 0 - 19% = 0
  315. 20 - 39% = 0
  316. 40 - 59% = 0
  317. 60 - 79% = 1
  318. 80 - 99% = 3
  319.  
  320.  
  321. Index IDX_CLIENTS1 (3)
  322. Root page: 18367, depth: 2, leaf buckets: 7, nodes: 3030
  323. Average node length: 5.42, total dup: 1936, max dup: 1854
  324. Average key length: 3.52, compression ratio: 1.04
  325. Average prefix length: 1.89, average data length: 1.78
  326. Clustering factor: 1284, ratio: 0.42
  327. Fill distribution:
  328. 0 - 19% = 1
  329. 20 - 39% = 0
  330. 40 - 59% = 4
  331. 60 - 79% = 0
  332. 80 - 99% = 2
  333.  
  334.  
  335. Index IDX_CLIENTS2 (4)
  336. Root page: 18373, depth: 2, leaf buckets: 12, nodes: 3027
  337. Average node length: 9.55, total dup: 265, max dup: 161
  338. Average key length: 7.65, compression ratio: 1.22
  339. Average prefix length: 4.55, average data length: 4.80
  340. Clustering factor: 2923, ratio: 0.97
  341. Fill distribution:
  342. 0 - 19% = 0
  343. 20 - 39% = 1
  344. 40 - 59% = 8
  345. 60 - 79% = 0
  346. 80 - 99% = 3
  347.  
  348.  
  349. Index IDX_CLIENTS3 (6)
  350. Root page: 18386, depth: 2, leaf buckets: 3, nodes: 3028
  351. Average node length: 3.11, total dup: 2955, max dup: 2947
  352. Average key length: 1.21, compression ratio: 0.20
  353. Average prefix length: 0.07, average data length: 0.16
  354. Clustering factor: 228, ratio: 0.08
  355. Fill distribution:
  356. 0 - 19% = 0
  357. 20 - 39% = 1
  358. 40 - 59% = 0
  359. 60 - 79% = 0
  360. 80 - 99% = 2
  361.  
  362.  
  363. Index IDX_CLIENTS4 (5)
  364. Root page: 18382, depth: 2, leaf buckets: 3, nodes: 3027
  365. Average node length: 2.92, total dup: 3019, max dup: 3017
  366. Average key length: 1.02, compression ratio: 0.02
  367. Average prefix length: 0.00, average data length: 0.02
  368. Clustering factor: 157, ratio: 0.05
  369. Fill distribution:
  370. 0 - 19% = 1
  371. 20 - 39% = 0
  372. 40 - 59% = 0
  373. 60 - 79% = 0
  374. 80 - 99% = 2
  375.  
  376.  
  377. Index IDX_RECHCLIENT (1)
  378. Root page: 18338, depth: 2, leaf buckets: 29, nodes: 3036
  379. Average node length: 27.30, total dup: 45, max dup: 11
  380. Average key length: 25.40, compression ratio: 1.12
  381. Average prefix length: 6.00, average data length: 22.43
  382. Clustering factor: 2983, ratio: 0.98
  383. Fill distribution:
  384. 0 - 19% = 0
  385. 20 - 39% = 8
  386. 40 - 59% = 0
  387. 60 - 79% = 9
  388. 80 - 99% = 12
  389.  
  390.  
  391. Index UPPERNOMCLIENTS (2)
  392. Root page: 18360, depth: 2, leaf buckets: 10, nodes: 3032
  393. Average node length: 7.89, total dup: 652, max dup: 16
  394. Average key length: 5.98, compression ratio: 1.17
  395. Average prefix length: 3.74, average data length: 3.27
  396. Clustering factor: 2978, ratio: 0.98
  397. Fill distribution:
  398. 0 - 19% = 0
  399. 20 - 39% = 0
  400. 40 - 59% = 8
  401. 60 - 79% = 0
  402. 80 - 99% = 2
  403.  
  404.  
  405. COMMANDES (143)
  406. Primary pointer page: 282, Index root page: 283
  407. Pointer pages: 1, data page slots: 1
  408. Data pages: 1, average fill: 2%
  409. Primary pages: 1, secondary pages: 0, swept pages: 1
  410. Empty pages: 0, full pages: 0
  411. Fill distribution:
  412. 0 - 19% = 1
  413. 20 - 39% = 0
  414. 40 - 59% = 0
  415. 60 - 79% = 0
  416. 80 - 99% = 0
  417.  
  418.  
  419. Index PK_COMMANDES (0)
  420. Root page: 17746, depth: 1, leaf buckets: 1, nodes: 2
  421. Average node length: 5.00, total dup: 0, max dup: 0
  422. Average key length: 3.00, compression ratio: 0.50
  423. Average prefix length: 0.00, average data length: 1.50
  424. Clustering factor: 1, ratio: 0.50
  425. Fill distribution:
  426. 0 - 19% = 1
  427. 20 - 39% = 0
  428. 40 - 59% = 0
  429. 60 - 79% = 0
  430. 80 - 99% = 0
  431.  
  432.  
  433. EXAMEN (130)
  434. Primary pointer page: 256, Index root page: 257
  435. Pointer pages: 5, data page slots: 3456
  436. Data pages: 3456, average fill: 89%
  437. Primary pages: 1057, secondary pages: 2399, swept pages: 1038
  438. Empty pages: 3, full pages: 3451
  439. Fill distribution:
  440. 0 - 19% = 6
  441. 20 - 39% = 3
  442. 40 - 59% = 25
  443. 60 - 79% = 342
  444. 80 - 99% = 3080
  445.  
  446.  
  447. Index FK_EXAMEN_1 (1)
  448. Root page: 18397, depth: 2, leaf buckets: 47, nodes: 28441
  449. Average node length: 4.46, total dup: 23869, max dup: 132
  450. Average key length: 2.17, compression ratio: 1.37
  451. Average prefix length: 2.80, average data length: 0.17
  452. Clustering factor: 24665, ratio: 0.87
  453. Fill distribution:
  454. 0 - 19% = 0
  455. 20 - 39% = 0
  456. 40 - 59% = 31
  457. 60 - 79% = 0
  458. 80 - 99% = 16
  459.  
  460.  
  461. Index PK_EXAMEN (0)
  462. Root page: 18273, depth: 2, leaf buckets: 38, nodes: 28441
  463. Average node length: 5.31, total dup: 0, max dup: 0
  464. Average key length: 3.02, compression ratio: 1.15
  465. Average prefix length: 2.45, average data length: 1.01
  466. Clustering factor: 4692, ratio: 0.16
  467. Fill distribution:
  468. 0 - 19% = 0
  469. 20 - 39% = 0
  470. 40 - 59% = 0
  471. 60 - 79% = 1
  472. 80 - 99% = 37
  473.  
  474.  
  475. EXAMENCP (133)
  476. Primary pointer page: 262, Index root page: 263
  477. Pointer pages: 1, data page slots: 176
  478. Data pages: 176, average fill: 81%
  479. Primary pages: 175, secondary pages: 1, swept pages: 173
  480. Empty pages: 0, full pages: 174
  481. Fill distribution:
  482. 0 - 19% = 1
  483. 20 - 39% = 1
  484. 40 - 59% = 0
  485. 60 - 79% = 113
  486. 80 - 99% = 61
  487.  
  488.  
  489. Index FK_EXAMENCP_1 (1)
  490. Root page: 18483, depth: 1, leaf buckets: 1, nodes: 600
  491. Average node length: 4.75, total dup: 213, max dup: 10
  492. Average key length: 2.88, compression ratio: 1.02
  493. Average prefix length: 2.18, average data length: 0.76
  494. Clustering factor: 554, ratio: 0.92
  495. Fill distribution:
  496. 0 - 19% = 0
  497. 20 - 39% = 0
  498. 40 - 59% = 0
  499. 60 - 79% = 1
  500. 80 - 99% = 0
  501.  
  502.  
  503. Index PK_EXAMENCP (0)
  504. Root page: 18145, depth: 1, leaf buckets: 1, nodes: 600
  505. Average node length: 4.91, total dup: 0, max dup: 0
  506. Average key length: 3.04, compression ratio: 0.94
  507. Average prefix length: 1.85, average data length: 1.02
  508. Clustering factor: 342, ratio: 0.57
  509. Fill distribution:
  510. 0 - 19% = 0
  511. 20 - 39% = 0
  512. 40 - 59% = 0
  513. 60 - 79% = 1
  514. 80 - 99% = 0
  515.  
  516.  
  517. FACTURES (131)
  518. Primary pointer page: 258, Index root page: 259
  519. Pointer pages: 3, data page slots: 1720
  520. Data pages: 1720, average fill: 80%
  521. Primary pages: 1708, secondary pages: 12, swept pages: 1683
  522. Empty pages: 6, full pages: 1701
  523. Fill distribution:
  524. 0 - 19% = 17
  525. 20 - 39% = 0
  526. 40 - 59% = 1
  527. 60 - 79% = 659
  528. 80 - 99% = 1043
  529.  
  530.  
  531. Index FK_FACTURES_1 (2)
  532. Root page: 18430, depth: 2, leaf buckets: 82, nodes: 53089
  533. Average node length: 4.05, total dup: 50140, max dup: 1888
  534. Average key length: 2.06, compression ratio: 1.42
  535. Average prefix length: 2.86, average data length: 0.06
  536. Clustering factor: 28534, ratio: 0.54
  537. Fill distribution:
  538. 0 - 19% = 0
  539. 20 - 39% = 1
  540. 40 - 59% = 56
  541. 60 - 79% = 0
  542. 80 - 99% = 25
  543.  
  544.  
  545. Index IDX_FACTURES_IDEXAM (1)
  546. Root page: 18218, depth: 2, leaf buckets: 55, nodes: 53089
  547. Average node length: 4.03, total dup: 26006, max dup: 26005
  548. Average key length: 2.04, compression ratio: 0.86
  549. Average prefix length: 1.24, average data length: 0.52
  550. Clustering factor: 7691, ratio: 0.14
  551. Fill distribution:
  552. 0 - 19% = 0
  553. 20 - 39% = 1
  554. 40 - 59% = 1
  555. 60 - 79% = 1
  556. 80 - 99% = 52
  557.  
  558.  
  559. Index PK_FACTURES (0)
  560. Root page: 18151, depth: 2, leaf buckets: 67, nodes: 53089
  561. Average node length: 5.00, total dup: 0, max dup: 0
  562. Average key length: 3.01, compression ratio: 1.21
  563. Average prefix length: 2.64, average data length: 1.01
  564. Clustering factor: 5934, ratio: 0.11
  565. Fill distribution:
  566. 0 - 19% = 1
  567. 20 - 39% = 0
  568. 40 - 59% = 0
  569. 60 - 79% = 0
  570. 80 - 99% = 66
  571.  
  572.  
  573. GROUPE_ACTES (150)
  574. Primary pointer page: 296, Index root page: 297
  575. Pointer pages: 1, data page slots: 1
  576. Data pages: 1, average fill: 33%
  577. Primary pages: 1, secondary pages: 0, swept pages: 1
  578. Empty pages: 0, full pages: 0
  579. Fill distribution:
  580. 0 - 19% = 0
  581. 20 - 39% = 1
  582. 40 - 59% = 0
  583. 60 - 79% = 0
  584. 80 - 99% = 0
  585.  
  586.  
  587. Index IDX_GRPID (0)
  588. Root page: 17606, depth: 1, leaf buckets: 1, nodes: 18
  589. Average node length: 3.61, total dup: 14, max dup: 5
  590. Average key length: 2.56, compression ratio: 1.17
  591. Average prefix length: 2.56, average data length: 0.44
  592. Clustering factor: 1, ratio: 0.06
  593. Fill distribution:
  594. 0 - 19% = 1
  595. 20 - 39% = 0
  596. 40 - 59% = 0
  597. 60 - 79% = 0
  598. 80 - 99% = 0
  599.  
  600.  
  601. HOSPIT (142)
  602. Primary pointer page: 280, Index root page: 281
  603. Pointer pages: 1, data page slots: 0
  604. Data pages: 0, average fill: 0%
  605. Primary pages: 0, secondary pages: 0, swept pages: 0
  606. Empty pages: 0, full pages: 0
  607. Fill distribution:
  608. 0 - 19% = 0
  609. 20 - 39% = 0
  610. 40 - 59% = 0
  611. 60 - 79% = 0
  612. 80 - 99% = 0
  613.  
  614.  
  615. Index FK_HOSPIT_1 (1)
  616. Root page: 18604, depth: 1, leaf buckets: 1, nodes: 0
  617. Average node length: 0.00, total dup: 0, max dup: 0
  618. Average key length: 0.00, compression ratio: 0.00
  619. Average prefix length: 0.00, average data length: 0.00
  620. Clustering factor: 0, ratio: 0.00
  621. Fill distribution:
  622. 0 - 19% = 1
  623. 20 - 39% = 0
  624. 40 - 59% = 0
  625. 60 - 79% = 0
  626. 80 - 99% = 0
  627.  
  628.  
  629. Index PK_HOSPIT (0)
  630. Root page: 17747, depth: 1, leaf buckets: 1, nodes: 0
  631. Average node length: 0.00, total dup: 0, max dup: 0
  632. Average key length: 0.00, compression ratio: 0.00
  633. Average prefix length: 0.00, average data length: 0.00
  634. Clustering factor: 0, ratio: 0.00
  635. Fill distribution:
  636. 0 - 19% = 1
  637. 20 - 39% = 0
  638. 40 - 59% = 0
  639. 60 - 79% = 0
  640. 80 - 99% = 0
  641.  
  642.  
  643. IMPUTATIONS (148)
  644. Primary pointer page: 292, Index root page: 293
  645. Pointer pages: 1, data page slots: 400
  646. Data pages: 400, average fill: 62%
  647. Primary pages: 400, secondary pages: 0, swept pages: 398
  648. Empty pages: 0, full pages: 399
  649. Fill distribution:
  650. 0 - 19% = 1
  651. 20 - 39% = 0
  652. 40 - 59% = 90
  653. 60 - 79% = 309
  654. 80 - 99% = 0
  655.  
  656.  
  657. Index PK_IMPUTATIONS (0)
  658. Root page: 17634, depth: 2, leaf buckets: 34, nodes: 26701
  659. Average node length: 4.96, total dup: 0, max dup: 0
  660. Average key length: 3.01, compression ratio: 1.14
  661. Average prefix length: 2.43, average data length: 1.01
  662. Clustering factor: 544, ratio: 0.02
  663. Fill distribution:
  664. 0 - 19% = 1
  665. 20 - 39% = 0
  666. 40 - 59% = 0
  667. 60 - 79% = 0
  668. 80 - 99% = 33
  669.  
  670.  
  671. IMPUTATIONS_LOTS (151)
  672. Primary pointer page: 298, Index root page: 299
  673. Pointer pages: 1, data page slots: 0
  674. Data pages: 0, average fill: 0%
  675. Primary pages: 0, secondary pages: 0, swept pages: 0
  676. Empty pages: 0, full pages: 0
  677. Fill distribution:
  678. 0 - 19% = 0
  679. 20 - 39% = 0
  680. 40 - 59% = 0
  681. 60 - 79% = 0
  682. 80 - 99% = 0
  683.  
  684.  
  685. Index PK_IMPUTATIONS_LOTS (0)
  686. Root page: 17605, depth: 1, leaf buckets: 1, nodes: 0
  687. Average node length: 0.00, total dup: 0, max dup: 0
  688. Average key length: 0.00, compression ratio: 0.00
  689. Average prefix length: 0.00, average data length: 0.00
  690. Clustering factor: 0, ratio: 0.00
  691. Fill distribution:
  692. 0 - 19% = 1
  693. 20 - 39% = 0
  694. 40 - 59% = 0
  695. 60 - 79% = 0
  696. 80 - 99% = 0
  697.  
  698.  
  699. LOGS (144)
  700. Primary pointer page: 284, Index root page: 285
  701. Pointer pages: 3, data page slots: 2384
  702. Data pages: 2384, average fill: 84%
  703. Primary pages: 1356, secondary pages: 1028, swept pages: 932
  704. Empty pages: 4, full pages: 2378
  705. Fill distribution:
  706. 0 - 19% = 5
  707. 20 - 39% = 1
  708. 40 - 59% = 0
  709. 60 - 79% = 1263
  710. 80 - 99% = 1115
  711.  
  712.  
  713. Index PK_LOGS (0)
  714. Root page: 17673, depth: 2, leaf buckets: 76, nodes: 59130
  715. Average node length: 5.11, total dup: 0, max dup: 0
  716. Average key length: 3.06, compression ratio: 1.20
  717. Average prefix length: 2.64, average data length: 1.03
  718. Clustering factor: 2340, ratio: 0.04
  719. Fill distribution:
  720. 0 - 19% = 0
  721. 20 - 39% = 1
  722. 40 - 59% = 0
  723. 60 - 79% = 0
  724. 80 - 99% = 75
  725.  
  726.  
  727. LOTS (141)
  728. Primary pointer page: 278, Index root page: 279
  729. Pointer pages: 1, data page slots: 24
  730. Data pages: 24, average fill: 59%
  731. Primary pages: 24, secondary pages: 0, swept pages: 16
  732. Empty pages: 3, full pages: 20
  733. Fill distribution:
  734. 0 - 19% = 4
  735. 20 - 39% = 0
  736. 40 - 59% = 0
  737. 60 - 79% = 20
  738. 80 - 99% = 0
  739.  
  740.  
  741. Index PK_LOTS (0)
  742. Root page: 17750, depth: 2, leaf buckets: 2, nodes: 1027
  743. Average node length: 4.14, total dup: 0, max dup: 0
  744. Average key length: 3.02, compression ratio: 0.99
  745. Average prefix length: 1.96, average data length: 1.01
  746. Clustering factor: 48, ratio: 0.05
  747. Fill distribution:
  748. 0 - 19% = 1
  749. 20 - 39% = 0
  750. 40 - 59% = 0
  751. 60 - 79% = 0
  752. 80 - 99% = 1
  753.  
  754.  
  755. Index REFLOTS (2)
  756. Root page: 18603, depth: 1, leaf buckets: 1, nodes: 1030
  757. Average node length: 3.48, total dup: 767, max dup: 38
  758. Average key length: 2.35, compression ratio: 1.23
  759. Average prefix length: 2.59, average data length: 0.30
  760. Clustering factor: 922, ratio: 0.90
  761. Fill distribution:
  762. 0 - 19% = 0
  763. 20 - 39% = 0
  764. 40 - 59% = 0
  765. 60 - 79% = 0
  766. 80 - 99% = 1
  767.  
  768.  
  769. Index UPPERNOMLOTS (1)
  770. Root page: 17752, depth: 1, leaf buckets: 1, nodes: 1027
  771. Average node length: 2.13, total dup: 1026, max dup: 1026
  772. Average key length: 1.00, compression ratio: 0.00
  773. Average prefix length: 0.00, average data length: 0.00
  774. Clustering factor: 21, ratio: 0.02
  775. Fill distribution:
  776. 0 - 19% = 0
  777. 20 - 39% = 0
  778. 40 - 59% = 1
  779. 60 - 79% = 0
  780. 80 - 99% = 0
  781.  
  782.  
  783. PARAMS (138)
  784. Primary pointer page: 272, Index root page: 273
  785. Pointer pages: 2, data page slots: 1552
  786. Data pages: 1552, average fill: 84%
  787. Primary pages: 1551, secondary pages: 1, swept pages: 1548
  788. Empty pages: 2, full pages: 1549
  789. Fill distribution:
  790. 0 - 19% = 2
  791. 20 - 39% = 0
  792. 40 - 59% = 1
  793. 60 - 79% = 0
  794. 80 - 99% = 1549
  795.  
  796.  
  797. Index PK_PARAMS (0)
  798. Root page: 17864, depth: 2, leaf buckets: 50, nodes: 39466
  799. Average node length: 5.00, total dup: 0, max dup: 0
  800. Average key length: 3.01, compression ratio: 1.26
  801. Average prefix length: 2.78, average data length: 1.00
  802. Clustering factor: 1576, ratio: 0.04
  803. Fill distribution:
  804. 0 - 19% = 1
  805. 20 - 39% = 0
  806. 40 - 59% = 0
  807. 60 - 79% = 0
  808. 80 - 99% = 49
  809.  
  810.  
  811. PRODUITS_COMMANDE (145)
  812. Primary pointer page: 286, Index root page: 287
  813. Pointer pages: 1, data page slots: 1
  814. Data pages: 1, average fill: 9%
  815. Primary pages: 1, secondary pages: 0, swept pages: 1
  816. Empty pages: 0, full pages: 0
  817. Fill distribution:
  818. 0 - 19% = 1
  819. 20 - 39% = 0
  820. 40 - 59% = 0
  821. 60 - 79% = 0
  822. 80 - 99% = 0
  823.  
  824.  
  825. Index FK_PRODUITS_COMMANDE_1 (1)
  826. Root page: 18605, depth: 1, leaf buckets: 1, nodes: 4
  827. Average node length: 4.00, total dup: 2, max dup: 2
  828. Average key length: 2.50, compression ratio: 0.50
  829. Average prefix length: 0.50, average data length: 0.75
  830. Clustering factor: 1, ratio: 0.25
  831. Fill distribution:
  832. 0 - 19% = 1
  833. 20 - 39% = 0
  834. 40 - 59% = 0
  835. 60 - 79% = 0
  836. 80 - 99% = 0
  837.  
  838.  
  839. Index PK_PRODUITS_COMMANDE_1 (0)
  840. Root page: 17670, depth: 1, leaf buckets: 1, nodes: 4
  841. Average node length: 5.00, total dup: 0, max dup: 0
  842. Average key length: 3.50, compression ratio: 0.57
  843. Average prefix length: 0.50, average data length: 1.50
  844. Clustering factor: 1, ratio: 0.25
  845. Fill distribution:
  846. 0 - 19% = 1
  847. 20 - 39% = 0
  848. 40 - 59% = 0
  849. 60 - 79% = 0
  850. 80 - 99% = 0
  851.  
  852.  
  853. RAPPELS (149)
  854. Primary pointer page: 294, Index root page: 295
  855. Pointer pages: 1, data page slots: 2
  856. Data pages: 2, average fill: 50%
  857. Primary pages: 1, secondary pages: 1, swept pages: 1
  858. Empty pages: 0, full pages: 0
  859. Fill distribution:
  860. 0 - 19% = 0
  861. 20 - 39% = 0
  862. 40 - 59% = 2
  863. 60 - 79% = 0
  864. 80 - 99% = 0
  865.  
  866.  
  867. Index PK_RAPPELS (0)
  868. Root page: 17607, depth: 1, leaf buckets: 1, nodes: 26
  869. Average node length: 4.35, total dup: 0, max dup: 0
  870. Average key length: 3.31, compression ratio: 0.85
  871. Average prefix length: 1.62, average data length: 1.19
  872. Clustering factor: 1, ratio: 0.04
  873. Fill distribution:
  874. 0 - 19% = 1
  875. 20 - 39% = 0
  876. 40 - 59% = 0
  877. 60 - 79% = 0
  878. 80 - 99% = 0
  879.  
  880.  
  881. RELANCES (136)
  882. Primary pointer page: 268, Index root page: 269
  883. Pointer pages: 1, data page slots: 144
  884. Data pages: 144, average fill: 80%
  885. Primary pages: 143, secondary pages: 1, swept pages: 95
  886. Empty pages: 2, full pages: 140
  887. Fill distribution:
  888. 0 - 19% = 3
  889. 20 - 39% = 0
  890. 40 - 59% = 1
  891. 60 - 79% = 20
  892. 80 - 99% = 120
  893.  
  894.  
  895. Index FK_RELANCES_1 (1)
  896. Root page: 18561, depth: 2, leaf buckets: 7, nodes: 4396
  897. Average node length: 4.48, total dup: 1836, max dup: 4
  898. Average key length: 2.61, compression ratio: 1.14
  899. Average prefix length: 2.38, average data length: 0.60
  900. Clustering factor: 3502, ratio: 0.80
  901. Fill distribution:
  902. 0 - 19% = 0
  903. 20 - 39% = 0
  904. 40 - 59% = 4
  905. 60 - 79% = 0
  906. 80 - 99% = 3
  907.  
  908.  
  909. Index PK_RELANCE (0)
  910. Root page: 17971, depth: 2, leaf buckets: 6, nodes: 4396
  911. Average node length: 4.88, total dup: 0, max dup: 0
  912. Average key length: 3.01, compression ratio: 0.99
  913. Average prefix length: 1.98, average data length: 1.00
  914. Clustering factor: 742, ratio: 0.17
  915. Fill distribution:
  916. 0 - 19% = 0
  917. 20 - 39% = 1
  918. 40 - 59% = 0
  919. 60 - 79% = 0
  920. 80 - 99% = 5
  921.  
  922.  
  923. REMISES (147)
  924. Primary pointer page: 290, Index root page: 291
  925. Pointer pages: 1, data page slots: 3
  926. Data pages: 3, average fill: 62%
  927. Primary pages: 3, secondary pages: 0, swept pages: 3
  928. Empty pages: 0, full pages: 2
  929. Fill distribution:
  930. 0 - 19% = 0
  931. 20 - 39% = 0
  932. 40 - 59% = 0
  933. 60 - 79% = 3
  934. 80 - 99% = 0
  935.  
  936.  
  937. Index PK_REMISES (0)
  938. Root page: 17666, depth: 1, leaf buckets: 1, nodes: 195
  939. Average node length: 4.01, total dup: 0, max dup: 0
  940. Average key length: 3.00, compression ratio: 0.88
  941. Average prefix length: 1.63, average data length: 1.01
  942. Clustering factor: 3, ratio: 0.02
  943. Fill distribution:
  944. 0 - 19% = 1
  945. 20 - 39% = 0
  946. 40 - 59% = 0
  947. 60 - 79% = 0
  948. 80 - 99% = 0
  949.  
  950.  
  951. TARIFS (132)
  952. Primary pointer page: 260, Index root page: 261
  953. Pointer pages: 1, data page slots: 80
  954. Data pages: 80, average fill: 87%
  955. Primary pages: 79, secondary pages: 1, swept pages: 24
  956. Empty pages: 1, full pages: 77
  957. Fill distribution:
  958. 0 - 19% = 1
  959. 20 - 39% = 0
  960. 40 - 59% = 1
  961. 60 - 79% = 1
  962. 80 - 99% = 77
  963.  
  964.  
  965. Index PK_TARIFS (0)
  966. Root page: 18148, depth: 2, leaf buckets: 2, nodes: 1594
  967. Average node length: 4.77, total dup: 0, max dup: 0
  968. Average key length: 3.01, compression ratio: 0.97
  969. Average prefix length: 1.92, average data length: 1.01
  970. Clustering factor: 326, ratio: 0.20
  971. Fill distribution:
  972. 0 - 19% = 0
  973. 20 - 39% = 0
  974. 40 - 59% = 0
  975. 60 - 79% = 0
  976. 80 - 99% = 2
  977.  
  978.  
  979. TEXTES (135)
  980. Primary pointer page: 266, Index root page: 267
  981. Pointer pages: 1, data page slots: 7
  982. Data pages: 7, average fill: 75%
  983. Primary pages: 2, secondary pages: 5, swept pages: 0
  984. Empty pages: 0, full pages: 5
  985. Fill distribution:
  986. 0 - 19% = 0
  987. 20 - 39% = 1
  988. 40 - 59% = 1
  989. 60 - 79% = 0
  990. 80 - 99% = 5
  991.  
  992.  
  993. Index PK_TEXTES (0)
  994. Root page: 17976, depth: 1, leaf buckets: 1, nodes: 39
  995. Average node length: 4.05, total dup: 0, max dup: 0
  996. Average key length: 3.00, compression ratio: 0.71
  997. Average prefix length: 1.10, average data length: 1.03
  998. Clustering factor: 2, ratio: 0.05
  999. Fill distribution:
  1000. 0 - 19% = 1
  1001. 20 - 39% = 0
  1002. 40 - 59% = 0
  1003. 60 - 79% = 0
  1004. 80 - 99% = 0
  1005.  
  1006.  
  1007. USERS (139)
  1008. Primary pointer page: 274, Index root page: 275
  1009. Pointer pages: 1, data page slots: 1
  1010. Data pages: 1, average fill: 49%
  1011. Primary pages: 1, secondary pages: 0, swept pages: 1
  1012. Empty pages: 0, full pages: 0
  1013. Fill distribution:
  1014. 0 - 19% = 0
  1015. 20 - 39% = 0
  1016. 40 - 59% = 1
  1017. 60 - 79% = 0
  1018. 80 - 99% = 0
  1019.  
  1020.  
  1021. Index PK_USER (0)
  1022. Root page: 17861, depth: 1, leaf buckets: 1, nodes: 11
  1023. Average node length: 4.18, total dup: 0, max dup: 0
  1024. Average key length: 3.00, compression ratio: 0.64
  1025. Average prefix length: 0.82, average data length: 1.09
  1026. Clustering factor: 1, ratio: 0.09
  1027. Fill distribution:
  1028. 0 - 19% = 1
  1029. 20 - 39% = 0
  1030. 40 - 59% = 0
  1031. 60 - 79% = 0
  1032. 80 - 99% = 0
  1033.  
  1034.  
  1035. Gstat completion time Fri Jan 17 13:15:01 2020
  1036.  
  1037.  
  1038. [/code]
  1039.  
  1040.  
  1041. and working one :
  1042. [code]
  1043.  
  1044. Database "C:\JSW\JDB.FDB"
  1045. Gstat execution time Fri Jan 17 13:23:59 2020
  1046.  
  1047.  
  1048. Database header page information:
  1049. Flags 0
  1050. Generation 7205
  1051. System Change Number 0
  1052. Page size 4096
  1053. ODS version 12.0
  1054. Oldest transaction 7197
  1055. Oldest active 7198
  1056. Oldest snapshot 7198
  1057. Next transaction 7199
  1058. Sequence number 0
  1059. Next attachment ID 434
  1060. Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
  1061. Shadow count 0
  1062. Page buffers 0
  1063. Next header page 0
  1064. Database dialect 3
  1065. Creation date Jan 11, 2020 8:34:10
  1066. Attributes force write
  1067.  
  1068.  
  1069. Variable header data:
  1070. Sweep interval: 1000
  1071. *END*
  1072.  
  1073.  
  1074.  
  1075.  
  1076. Database file sequence:
  1077. File C:\JSW\JDB.FDB is the only file
  1078.  
  1079.  
  1080. Analyzing database pages ...
  1081. ACTES (134)
  1082. Primary pointer page: 264, Index root page: 265
  1083. Pointer pages: 4, data page slots: 3024
  1084. Data pages: 3024, average fill: 86%
  1085. Primary pages: 3024, secondary pages: 0, swept pages: 3008
  1086. Empty pages: 0, full pages: 3023
  1087. Fill distribution:
  1088. 0 - 19% = 1
  1089. 20 - 39% = 0
  1090. 40 - 59% = 0
  1091. 60 - 79% = 0
  1092. 80 - 99% = 3023
  1093.  
  1094.  
  1095. Index FK_ACTES_1 (2)
  1096. Root page: 18486, depth: 2, leaf buckets: 74, nodes: 62838
  1097. Average node length: 4.70, total dup: 35764, max dup: 20
  1098. Average key length: 2.45, compression ratio: 1.41
  1099. Average prefix length: 3.02, average data length: 0.44
  1100. Clustering factor: 8500, ratio: 0.14
  1101. Fill distribution:
  1102. 0 - 19% = 0
  1103. 20 - 39% = 0
  1104. 40 - 59% = 0
  1105. 60 - 79% = 1
  1106. 80 - 99% = 73
  1107.  
  1108.  
  1109. Index IDX_IDENTACTE (1)
  1110. Root page: 18063, depth: 2, leaf buckets: 83, nodes: 62838
  1111. Average node length: 5.28, total dup: 0, max dup: 0
  1112. Average key length: 3.03, compression ratio: 1.22
  1113. Average prefix length: 2.67, average data length: 1.02
  1114. Clustering factor: 5829, ratio: 0.09
  1115. Fill distribution:
  1116. 0 - 19% = 0
  1117. 20 - 39% = 0
  1118. 40 - 59% = 0
  1119. 60 - 79% = 1
  1120. 80 - 99% = 82
  1121.  
  1122.  
  1123. Index PK_ACTES (0)
  1124. Root page: 17979, depth: 2, leaf buckets: 83, nodes: 62838
  1125. Average node length: 5.28, total dup: 0, max dup: 0
  1126. Average key length: 3.03, compression ratio: 1.22
  1127. Average prefix length: 2.67, average data length: 1.02
  1128. Clustering factor: 5829, ratio: 0.09
  1129. Fill distribution:
  1130. 0 - 19% = 0
  1131. 20 - 39% = 0
  1132. 40 - 59% = 0
  1133. 60 - 79% = 1
  1134. 80 - 99% = 82
  1135.  
  1136.  
  1137. AGENDA (137)
  1138. Primary pointer page: 270, Index root page: 271
  1139. Pointer pages: 2, data page slots: 1224
  1140. Data pages: 1224, average fill: 87%
  1141. Primary pages: 1221, secondary pages: 3, swept pages: 1189
  1142. Empty pages: 2, full pages: 1218
  1143. Fill distribution:
  1144. 0 - 19% = 4
  1145. 20 - 39% = 1
  1146. 40 - 59% = 1
  1147. 60 - 79% = 0
  1148. 80 - 99% = 1218
  1149.  
  1150.  
  1151. Index FK_AGENDA_1 (2)
  1152. Root page: 18567, depth: 2, leaf buckets: 18, nodes: 23731
  1153. Average node length: 2.98, total dup: 23730, max dup: 23730
  1154. Average key length: 1.00, compression ratio: 0.00
  1155. Average prefix length: 0.00, average data length: 0.00
  1156. Clustering factor: 1219, ratio: 0.05
  1157. Fill distribution:
  1158. 0 - 19% = 0
  1159. 20 - 39% = 0
  1160. 40 - 59% = 1
  1161. 60 - 79% = 0
  1162. 80 - 99% = 17
  1163.  
  1164.  
  1165. Index FK_AGENDA_2 (3)
  1166. Root page: 18586, depth: 2, leaf buckets: 18, nodes: 23731
  1167. Average node length: 2.98, total dup: 23730, max dup: 23730
  1168. Average key length: 1.00, compression ratio: 0.00
  1169. Average prefix length: 0.00, average data length: 0.00
  1170. Clustering factor: 1219, ratio: 0.05
  1171. Fill distribution:
  1172. 0 - 19% = 0
  1173. 20 - 39% = 0
  1174. 40 - 59% = 1
  1175. 60 - 79% = 0
  1176. 80 - 99% = 17
  1177.  
  1178.  
  1179. Index IDX_AGENDA (1)
  1180. Root page: 17946, depth: 2, leaf buckets: 25, nodes: 23737
  1181. Average node length: 4.06, total dup: 21993, max dup: 36
  1182. Average key length: 2.08, compression ratio: 1.92
  1183. Average prefix length: 3.92, average data length: 0.08
  1184. Clustering factor: 11579, ratio: 0.49
  1185. Fill distribution:
  1186. 0 - 19% = 0
  1187. 20 - 39% = 0
  1188. 40 - 59% = 2
  1189. 60 - 79% = 0
  1190. 80 - 99% = 23
  1191.  
  1192.  
  1193. Index PK_AGENDA (0)
  1194. Root page: 17915, depth: 2, leaf buckets: 30, nodes: 23731
  1195. Average node length: 5.06, total dup: 0, max dup: 0
  1196. Average key length: 3.07, compression ratio: 1.11
  1197. Average prefix length: 2.38, average data length: 1.04
  1198. Clustering factor: 3484, ratio: 0.15
  1199. Fill distribution:
  1200. 0 - 19% = 0
  1201. 20 - 39% = 0
  1202. 40 - 59% = 0
  1203. 60 - 79% = 0
  1204. 80 - 99% = 30
  1205.  
  1206.  
  1207. ANIMAUX (129)
  1208. Primary pointer page: 253, Index root page: 254
  1209. Pointer pages: 1, data page slots: 152
  1210. Data pages: 152, average fill: 82%
  1211. Primary pages: 151, secondary pages: 1, swept pages: 89
  1212. Empty pages: 0, full pages: 150
  1213. Fill distribution:
  1214. 0 - 19% = 0
  1215. 20 - 39% = 1
  1216. 40 - 59% = 0
  1217. 60 - 79% = 19
  1218. 80 - 99% = 132
  1219.  
  1220.  
  1221. Index IDX_ANIMAUX1 (2)
  1222. Root page: 18328, depth: 2, leaf buckets: 4, nodes: 4722
  1223. Average node length: 2.90, total dup: 4715, max dup: 4714
  1224. Average key length: 1.01, compression ratio: 0.01
  1225. Average prefix length: 0.00, average data length: 0.01
  1226. Clustering factor: 158, ratio: 0.03
  1227. Fill distribution:
  1228. 0 - 19% = 0
  1229. 20 - 39% = 1
  1230. 40 - 59% = 0
  1231. 60 - 79% = 0
  1232. 80 - 99% = 3
  1233.  
  1234.  
  1235. Index PK_ANIMAUX (0)
  1236. Root page: 18313, depth: 2, leaf buckets: 6, nodes: 4721
  1237. Average node length: 4.90, total dup: 0, max dup: 0
  1238. Average key length: 3.01, compression ratio: 0.99
  1239. Average prefix length: 1.97, average data length: 1.00
  1240. Clustering factor: 797, ratio: 0.17
  1241. Fill distribution:
  1242. 0 - 19% = 0
  1243. 20 - 39% = 0
  1244. 40 - 59% = 0
  1245. 60 - 79% = 1
  1246. 80 - 99% = 5
  1247.  
  1248.  
  1249. Index REFCUSTINORDERS (3)
  1250. Root page: 18390, depth: 2, leaf buckets: 7, nodes: 4722
  1251. Average node length: 4.52, total dup: 1753, max dup: 25
  1252. Average key length: 2.63, compression ratio: 1.12
  1253. Average prefix length: 2.32, average data length: 0.63
  1254. Clustering factor: 2726, ratio: 0.58
  1255. Fill distribution:
  1256. 0 - 19% = 0
  1257. 20 - 39% = 1
  1258. 40 - 59% = 2
  1259. 60 - 79% = 0
  1260. 80 - 99% = 4
  1261.  
  1262.  
  1263. Index UPPERNOMANIMAL (1)
  1264. Root page: 18320, depth: 2, leaf buckets: 10, nodes: 4723
  1265. Average node length: 5.94, total dup: 2235, max dup: 42
  1266. Average key length: 4.05, compression ratio: 1.41
  1267. Average prefix length: 4.07, average data length: 1.63
  1268. Clustering factor: 4606, ratio: 0.98
  1269. Fill distribution:
  1270. 0 - 19% = 0
  1271. 20 - 39% = 3
  1272. 40 - 59% = 0
  1273. 60 - 79% = 3
  1274. 80 - 99% = 4
  1275.  
  1276.  
  1277. CAISSE (146)
  1278. Primary pointer page: 288, Index root page: 289
  1279. Pointer pages: 1, data page slots: 24
  1280. Data pages: 24, average fill: 63%
  1281. Primary pages: 24, secondary pages: 0, swept pages: 20
  1282. Empty pages: 3, full pages: 20
  1283. Fill distribution:
  1284. 0 - 19% = 3
  1285. 20 - 39% = 0
  1286. 40 - 59% = 1
  1287. 60 - 79% = 20
  1288. 80 - 99% = 0
  1289.  
  1290.  
  1291. Index PK_CAISSE (0)
  1292. Root page: 17669, depth: 2, leaf buckets: 2, nodes: 1017
  1293. Average node length: 4.15, total dup: 0, max dup: 0
  1294. Average key length: 3.00, compression ratio: 0.96
  1295. Average prefix length: 1.89, average data length: 1.00
  1296. Clustering factor: 49, ratio: 0.05
  1297. Fill distribution:
  1298. 0 - 19% = 1
  1299. 20 - 39% = 0
  1300. 40 - 59% = 0
  1301. 60 - 79% = 0
  1302. 80 - 99% = 1
  1303.  
  1304.  
  1305. CATALOGUE (140)
  1306. Primary pointer page: 276, Index root page: 277
  1307. Pointer pages: 4, data page slots: 2752
  1308. Data pages: 2752, average fill: 84%
  1309. Primary pages: 2752, secondary pages: 0, swept pages: 2745
  1310. Empty pages: 7, full pages: 2744
  1311. Fill distribution:
  1312. 0 - 19% = 7
  1313. 20 - 39% = 0
  1314. 40 - 59% = 1
  1315. 60 - 79% = 1
  1316. 80 - 99% = 2743
  1317.  
  1318.  
  1319. Index PK_REFERENCES (0)
  1320. Root page: 17755, depth: 2, leaf buckets: 107, nodes: 65876
  1321. Average node length: 6.49, total dup: 0, max dup: 0
  1322. Average key length: 4.31, compression ratio: 1.42
  1323. Average prefix length: 4.36, average data length: 1.75
  1324. Clustering factor: 37022, ratio: 0.56
  1325. Fill distribution:
  1326. 0 - 19% = 0
  1327. 20 - 39% = 0
  1328. 40 - 59% = 0
  1329. 60 - 79% = 0
  1330. 80 - 99% = 107
  1331.  
  1332.  
  1333. CLIENTS (128)
  1334. Primary pointer page: 251, Index root page: 252
  1335. Pointer pages: 28, data page slots: 8896
  1336. Data pages: 344, average fill: 41%
  1337. Primary pages: 152, secondary pages: 192, swept pages: 0
  1338. Empty pages: 161, full pages: 160
  1339. Fill distribution:
  1340. 0 - 19% = 182
  1341. 20 - 39% = 2
  1342. 40 - 59% = 0
  1343. 60 - 79% = 1
  1344. 80 - 99% = 159
  1345.  
  1346.  
  1347. Index CLIENTS_PRIMARY (0)
  1348. Root page: 18333, depth: 2, leaf buckets: 4, nodes: 3027
  1349. Average node length: 4.90, total dup: 0, max dup: 0
  1350. Average key length: 3.00, compression ratio: 0.98
  1351. Average prefix length: 1.96, average data length: 1.00
  1352. Clustering factor: 1134, ratio: 0.37
  1353. Fill distribution:
  1354. 0 - 19% = 0
  1355. 20 - 39% = 0
  1356. 40 - 59% = 0
  1357. 60 - 79% = 1
  1358. 80 - 99% = 3
  1359.  
  1360.  
  1361. Index IDX_CLIENTS1 (3)
  1362. Root page: 18367, depth: 2, leaf buckets: 7, nodes: 3027
  1363. Average node length: 5.42, total dup: 1933, max dup: 1851
  1364. Average key length: 3.52, compression ratio: 1.04
  1365. Average prefix length: 1.89, average data length: 1.78
  1366. Clustering factor: 1283, ratio: 0.42
  1367. Fill distribution:
  1368. 0 - 19% = 1
  1369. 20 - 39% = 0
  1370. 40 - 59% = 4
  1371. 60 - 79% = 0
  1372. 80 - 99% = 2
  1373.  
  1374.  
  1375. Index IDX_CLIENTS2 (4)
  1376. Root page: 18373, depth: 2, leaf buckets: 12, nodes: 3027
  1377. Average node length: 9.55, total dup: 265, max dup: 161
  1378. Average key length: 7.65, compression ratio: 1.22
  1379. Average prefix length: 4.55, average data length: 4.80
  1380. Clustering factor: 2923, ratio: 0.97
  1381. Fill distribution:
  1382. 0 - 19% = 0
  1383. 20 - 39% = 1
  1384. 40 - 59% = 8
  1385. 60 - 79% = 0
  1386. 80 - 99% = 3
  1387.  
  1388.  
  1389. Index IDX_CLIENTS3 (6)
  1390. Root page: 18386, depth: 2, leaf buckets: 3, nodes: 3027
  1391. Average node length: 3.11, total dup: 2954, max dup: 2946
  1392. Average key length: 1.21, compression ratio: 0.20
  1393. Average prefix length: 0.07, average data length: 0.16
  1394. Clustering factor: 228, ratio: 0.08
  1395. Fill distribution:
  1396. 0 - 19% = 0
  1397. 20 - 39% = 1
  1398. 40 - 59% = 0
  1399. 60 - 79% = 0
  1400. 80 - 99% = 2
  1401.  
  1402.  
  1403. Index IDX_CLIENTS4 (5)
  1404. Root page: 18382, depth: 2, leaf buckets: 3, nodes: 3027
  1405. Average node length: 2.92, total dup: 3019, max dup: 3017
  1406. Average key length: 1.02, compression ratio: 0.02
  1407. Average prefix length: 0.00, average data length: 0.02
  1408. Clustering factor: 157, ratio: 0.05
  1409. Fill distribution:
  1410. 0 - 19% = 1
  1411. 20 - 39% = 0
  1412. 40 - 59% = 0
  1413. 60 - 79% = 0
  1414. 80 - 99% = 2
  1415.  
  1416.  
  1417. Index IDX_RECHCLIENT (1)
  1418. Root page: 18338, depth: 2, leaf buckets: 29, nodes: 3027
  1419. Average node length: 27.31, total dup: 45, max dup: 11
  1420. Average key length: 25.40, compression ratio: 1.12
  1421. Average prefix length: 5.99, average data length: 22.43
  1422. Clustering factor: 2978, ratio: 0.98
  1423. Fill distribution:
  1424. 0 - 19% = 0
  1425. 20 - 39% = 8
  1426. 40 - 59% = 0
  1427. 60 - 79% = 9
  1428. 80 - 99% = 12
  1429.  
  1430.  
  1431. Index UPPERNOMCLIENTS (2)
  1432. Root page: 18360, depth: 2, leaf buckets: 10, nodes: 3027
  1433. Average node length: 7.89, total dup: 651, max dup: 16
  1434. Average key length: 5.98, compression ratio: 1.17
  1435. Average prefix length: 3.74, average data length: 3.28
  1436. Clustering factor: 2974, ratio: 0.98
  1437. Fill distribution:
  1438. 0 - 19% = 0
  1439. 20 - 39% = 0
  1440. 40 - 59% = 8
  1441. 60 - 79% = 0
  1442. 80 - 99% = 2
  1443.  
  1444.  
  1445. COMMANDES (143)
  1446. Primary pointer page: 282, Index root page: 283
  1447. Pointer pages: 1, data page slots: 1
  1448. Data pages: 1, average fill: 2%
  1449. Primary pages: 1, secondary pages: 0, swept pages: 1
  1450. Empty pages: 0, full pages: 0
  1451. Fill distribution:
  1452. 0 - 19% = 1
  1453. 20 - 39% = 0
  1454. 40 - 59% = 0
  1455. 60 - 79% = 0
  1456. 80 - 99% = 0
  1457.  
  1458.  
  1459. Index PK_COMMANDES (0)
  1460. Root page: 17746, depth: 1, leaf buckets: 1, nodes: 2
  1461. Average node length: 5.00, total dup: 0, max dup: 0
  1462. Average key length: 3.00, compression ratio: 0.50
  1463. Average prefix length: 0.00, average data length: 1.50
  1464. Clustering factor: 1, ratio: 0.50
  1465. Fill distribution:
  1466. 0 - 19% = 1
  1467. 20 - 39% = 0
  1468. 40 - 59% = 0
  1469. 60 - 79% = 0
  1470. 80 - 99% = 0
  1471.  
  1472.  
  1473. EXAMEN (130)
  1474. Primary pointer page: 256, Index root page: 257
  1475. Pointer pages: 5, data page slots: 3456
  1476. Data pages: 3456, average fill: 89%
  1477. Primary pages: 1057, secondary pages: 2399, swept pages: 1038
  1478. Empty pages: 3, full pages: 3451
  1479. Fill distribution:
  1480. 0 - 19% = 6
  1481. 20 - 39% = 3
  1482. 40 - 59% = 25
  1483. 60 - 79% = 342
  1484. 80 - 99% = 3080
  1485.  
  1486.  
  1487. Index FK_EXAMEN_1 (1)
  1488. Root page: 18397, depth: 2, leaf buckets: 47, nodes: 28441
  1489. Average node length: 4.46, total dup: 23869, max dup: 132
  1490. Average key length: 2.17, compression ratio: 1.37
  1491. Average prefix length: 2.80, average data length: 0.17
  1492. Clustering factor: 24665, ratio: 0.87
  1493. Fill distribution:
  1494. 0 - 19% = 0
  1495. 20 - 39% = 0
  1496. 40 - 59% = 31
  1497. 60 - 79% = 0
  1498. 80 - 99% = 16
  1499.  
  1500.  
  1501. Index PK_EXAMEN (0)
  1502. Root page: 18273, depth: 2, leaf buckets: 38, nodes: 28441
  1503. Average node length: 5.31, total dup: 0, max dup: 0
  1504. Average key length: 3.02, compression ratio: 1.15
  1505. Average prefix length: 2.45, average data length: 1.01
  1506. Clustering factor: 4692, ratio: 0.16
  1507. Fill distribution:
  1508. 0 - 19% = 0
  1509. 20 - 39% = 0
  1510. 40 - 59% = 0
  1511. 60 - 79% = 1
  1512. 80 - 99% = 37
  1513.  
  1514.  
  1515. EXAMENCP (133)
  1516. Primary pointer page: 262, Index root page: 263
  1517. Pointer pages: 1, data page slots: 176
  1518. Data pages: 176, average fill: 81%
  1519. Primary pages: 175, secondary pages: 1, swept pages: 173
  1520. Empty pages: 0, full pages: 174
  1521. Fill distribution:
  1522. 0 - 19% = 1
  1523. 20 - 39% = 1
  1524. 40 - 59% = 0
  1525. 60 - 79% = 113
  1526. 80 - 99% = 61
  1527.  
  1528.  
  1529. Index FK_EXAMENCP_1 (1)
  1530. Root page: 18483, depth: 1, leaf buckets: 1, nodes: 600
  1531. Average node length: 4.75, total dup: 213, max dup: 10
  1532. Average key length: 2.88, compression ratio: 1.02
  1533. Average prefix length: 2.18, average data length: 0.76
  1534. Clustering factor: 554, ratio: 0.92
  1535. Fill distribution:
  1536. 0 - 19% = 0
  1537. 20 - 39% = 0
  1538. 40 - 59% = 0
  1539. 60 - 79% = 1
  1540. 80 - 99% = 0
  1541.  
  1542.  
  1543. Index PK_EXAMENCP (0)
  1544. Root page: 18145, depth: 1, leaf buckets: 1, nodes: 600
  1545. Average node length: 4.91, total dup: 0, max dup: 0
  1546. Average key length: 3.04, compression ratio: 0.94
  1547. Average prefix length: 1.85, average data length: 1.02
  1548. Clustering factor: 342, ratio: 0.57
  1549. Fill distribution:
  1550. 0 - 19% = 0
  1551. 20 - 39% = 0
  1552. 40 - 59% = 0
  1553. 60 - 79% = 1
  1554. 80 - 99% = 0
  1555.  
  1556.  
  1557. FACTURES (131)
  1558. Primary pointer page: 258, Index root page: 259
  1559. Pointer pages: 3, data page slots: 1720
  1560. Data pages: 1720, average fill: 80%
  1561. Primary pages: 1708, secondary pages: 12, swept pages: 1683
  1562. Empty pages: 6, full pages: 1701
  1563. Fill distribution:
  1564. 0 - 19% = 17
  1565. 20 - 39% = 0
  1566. 40 - 59% = 1
  1567. 60 - 79% = 659
  1568. 80 - 99% = 1043
  1569.  
  1570.  
  1571. Index FK_FACTURES_1 (2)
  1572. Root page: 18430, depth: 2, leaf buckets: 82, nodes: 53089
  1573. Average node length: 4.05, total dup: 50140, max dup: 1888
  1574. Average key length: 2.06, compression ratio: 1.42
  1575. Average prefix length: 2.86, average data length: 0.06
  1576. Clustering factor: 28534, ratio: 0.54
  1577. Fill distribution:
  1578. 0 - 19% = 0
  1579. 20 - 39% = 1
  1580. 40 - 59% = 56
  1581. 60 - 79% = 0
  1582. 80 - 99% = 25
  1583.  
  1584.  
  1585. Index IDX_FACTURES_IDEXAM (1)
  1586. Root page: 18218, depth: 2, leaf buckets: 55, nodes: 53089
  1587. Average node length: 4.03, total dup: 26006, max dup: 26005
  1588. Average key length: 2.04, compression ratio: 0.86
  1589. Average prefix length: 1.24, average data length: 0.52
  1590. Clustering factor: 7691, ratio: 0.14
  1591. Fill distribution:
  1592. 0 - 19% = 0
  1593. 20 - 39% = 1
  1594. 40 - 59% = 1
  1595. 60 - 79% = 1
  1596. 80 - 99% = 52
  1597.  
  1598.  
  1599. Index PK_FACTURES (0)
  1600. Root page: 18151, depth: 2, leaf buckets: 67, nodes: 53089
  1601. Average node length: 5.00, total dup: 0, max dup: 0
  1602. Average key length: 3.01, compression ratio: 1.21
  1603. Average prefix length: 2.64, average data length: 1.01
  1604. Clustering factor: 5934, ratio: 0.11
  1605. Fill distribution:
  1606. 0 - 19% = 1
  1607. 20 - 39% = 0
  1608. 40 - 59% = 0
  1609. 60 - 79% = 0
  1610. 80 - 99% = 66
  1611.  
  1612.  
  1613. GROUPE_ACTES (150)
  1614. Primary pointer page: 296, Index root page: 297
  1615. Pointer pages: 1, data page slots: 1
  1616. Data pages: 1, average fill: 33%
  1617. Primary pages: 1, secondary pages: 0, swept pages: 1
  1618. Empty pages: 0, full pages: 0
  1619. Fill distribution:
  1620. 0 - 19% = 0
  1621. 20 - 39% = 1
  1622. 40 - 59% = 0
  1623. 60 - 79% = 0
  1624. 80 - 99% = 0
  1625.  
  1626.  
  1627. Index IDX_GRPID (0)
  1628. Root page: 17606, depth: 1, leaf buckets: 1, nodes: 18
  1629. Average node length: 3.61, total dup: 14, max dup: 5
  1630. Average key length: 2.56, compression ratio: 1.17
  1631. Average prefix length: 2.56, average data length: 0.44
  1632. Clustering factor: 1, ratio: 0.06
  1633. Fill distribution:
  1634. 0 - 19% = 1
  1635. 20 - 39% = 0
  1636. 40 - 59% = 0
  1637. 60 - 79% = 0
  1638. 80 - 99% = 0
  1639.  
  1640.  
  1641. HOSPIT (142)
  1642. Primary pointer page: 280, Index root page: 281
  1643. Pointer pages: 1, data page slots: 0
  1644. Data pages: 0, average fill: 0%
  1645. Primary pages: 0, secondary pages: 0, swept pages: 0
  1646. Empty pages: 0, full pages: 0
  1647. Fill distribution:
  1648. 0 - 19% = 0
  1649. 20 - 39% = 0
  1650. 40 - 59% = 0
  1651. 60 - 79% = 0
  1652. 80 - 99% = 0
  1653.  
  1654.  
  1655. Index FK_HOSPIT_1 (1)
  1656. Root page: 18604, depth: 1, leaf buckets: 1, nodes: 0
  1657. Average node length: 0.00, total dup: 0, max dup: 0
  1658. Average key length: 0.00, compression ratio: 0.00
  1659. Average prefix length: 0.00, average data length: 0.00
  1660. Clustering factor: 0, ratio: 0.00
  1661. Fill distribution:
  1662. 0 - 19% = 1
  1663. 20 - 39% = 0
  1664. 40 - 59% = 0
  1665. 60 - 79% = 0
  1666. 80 - 99% = 0
  1667.  
  1668.  
  1669. Index PK_HOSPIT (0)
  1670. Root page: 17747, depth: 1, leaf buckets: 1, nodes: 0
  1671. Average node length: 0.00, total dup: 0, max dup: 0
  1672. Average key length: 0.00, compression ratio: 0.00
  1673. Average prefix length: 0.00, average data length: 0.00
  1674. Clustering factor: 0, ratio: 0.00
  1675. Fill distribution:
  1676. 0 - 19% = 1
  1677. 20 - 39% = 0
  1678. 40 - 59% = 0
  1679. 60 - 79% = 0
  1680. 80 - 99% = 0
  1681.  
  1682.  
  1683. IMPUTATIONS (148)
  1684. Primary pointer page: 292, Index root page: 293
  1685. Pointer pages: 1, data page slots: 400
  1686. Data pages: 400, average fill: 62%
  1687. Primary pages: 400, secondary pages: 0, swept pages: 398
  1688. Empty pages: 0, full pages: 399
  1689. Fill distribution:
  1690. 0 - 19% = 1
  1691. 20 - 39% = 0
  1692. 40 - 59% = 90
  1693. 60 - 79% = 309
  1694. 80 - 99% = 0
  1695.  
  1696.  
  1697. Index PK_IMPUTATIONS (0)
  1698. Root page: 17634, depth: 2, leaf buckets: 34, nodes: 26701
  1699. Average node length: 4.96, total dup: 0, max dup: 0
  1700. Average key length: 3.01, compression ratio: 1.14
  1701. Average prefix length: 2.43, average data length: 1.01
  1702. Clustering factor: 544, ratio: 0.02
  1703. Fill distribution:
  1704. 0 - 19% = 1
  1705. 20 - 39% = 0
  1706. 40 - 59% = 0
  1707. 60 - 79% = 0
  1708. 80 - 99% = 33
  1709.  
  1710.  
  1711. IMPUTATIONS_LOTS (151)
  1712. Primary pointer page: 298, Index root page: 299
  1713. Pointer pages: 1, data page slots: 0
  1714. Data pages: 0, average fill: 0%
  1715. Primary pages: 0, secondary pages: 0, swept pages: 0
  1716. Empty pages: 0, full pages: 0
  1717. Fill distribution:
  1718. 0 - 19% = 0
  1719. 20 - 39% = 0
  1720. 40 - 59% = 0
  1721. 60 - 79% = 0
  1722. 80 - 99% = 0
  1723.  
  1724.  
  1725. Index PK_IMPUTATIONS_LOTS (0)
  1726. Root page: 17605, depth: 1, leaf buckets: 1, nodes: 0
  1727. Average node length: 0.00, total dup: 0, max dup: 0
  1728. Average key length: 0.00, compression ratio: 0.00
  1729. Average prefix length: 0.00, average data length: 0.00
  1730. Clustering factor: 0, ratio: 0.00
  1731. Fill distribution:
  1732. 0 - 19% = 1
  1733. 20 - 39% = 0
  1734. 40 - 59% = 0
  1735. 60 - 79% = 0
  1736. 80 - 99% = 0
  1737.  
  1738.  
  1739. LOGS (144)
  1740. Primary pointer page: 284, Index root page: 285
  1741. Pointer pages: 3, data page slots: 2384
  1742. Data pages: 2384, average fill: 84%
  1743. Primary pages: 1356, secondary pages: 1028, swept pages: 932
  1744. Empty pages: 4, full pages: 2378
  1745. Fill distribution:
  1746. 0 - 19% = 5
  1747. 20 - 39% = 1
  1748. 40 - 59% = 0
  1749. 60 - 79% = 1263
  1750. 80 - 99% = 1115
  1751.  
  1752.  
  1753. Index PK_LOGS (0)
  1754. Root page: 17673, depth: 2, leaf buckets: 76, nodes: 59130
  1755. Average node length: 5.11, total dup: 0, max dup: 0
  1756. Average key length: 3.06, compression ratio: 1.20
  1757. Average prefix length: 2.64, average data length: 1.03
  1758. Clustering factor: 2340, ratio: 0.04
  1759. Fill distribution:
  1760. 0 - 19% = 0
  1761. 20 - 39% = 1
  1762. 40 - 59% = 0
  1763. 60 - 79% = 0
  1764. 80 - 99% = 75
  1765.  
  1766.  
  1767. LOTS (141)
  1768. Primary pointer page: 278, Index root page: 279
  1769. Pointer pages: 1, data page slots: 24
  1770. Data pages: 24, average fill: 59%
  1771. Primary pages: 24, secondary pages: 0, swept pages: 16
  1772. Empty pages: 3, full pages: 20
  1773. Fill distribution:
  1774. 0 - 19% = 4
  1775. 20 - 39% = 0
  1776. 40 - 59% = 0
  1777. 60 - 79% = 20
  1778. 80 - 99% = 0
  1779.  
  1780.  
  1781. Index PK_LOTS (0)
  1782. Root page: 17750, depth: 2, leaf buckets: 2, nodes: 1027
  1783. Average node length: 4.14, total dup: 0, max dup: 0
  1784. Average key length: 3.02, compression ratio: 0.99
  1785. Average prefix length: 1.96, average data length: 1.01
  1786. Clustering factor: 48, ratio: 0.05
  1787. Fill distribution:
  1788. 0 - 19% = 1
  1789. 20 - 39% = 0
  1790. 40 - 59% = 0
  1791. 60 - 79% = 0
  1792. 80 - 99% = 1
  1793.  
  1794.  
  1795. Index REFLOTS (2)
  1796. Root page: 18603, depth: 1, leaf buckets: 1, nodes: 1030
  1797. Average node length: 3.48, total dup: 767, max dup: 38
  1798. Average key length: 2.35, compression ratio: 1.23
  1799. Average prefix length: 2.59, average data length: 0.30
  1800. Clustering factor: 922, ratio: 0.90
  1801. Fill distribution:
  1802. 0 - 19% = 0
  1803. 20 - 39% = 0
  1804. 40 - 59% = 0
  1805. 60 - 79% = 0
  1806. 80 - 99% = 1
  1807.  
  1808.  
  1809. Index UPPERNOMLOTS (1)
  1810. Root page: 17752, depth: 1, leaf buckets: 1, nodes: 1027
  1811. Average node length: 2.13, total dup: 1026, max dup: 1026
  1812. Average key length: 1.00, compression ratio: 0.00
  1813. Average prefix length: 0.00, average data length: 0.00
  1814. Clustering factor: 21, ratio: 0.02
  1815. Fill distribution:
  1816. 0 - 19% = 0
  1817. 20 - 39% = 0
  1818. 40 - 59% = 1
  1819. 60 - 79% = 0
  1820. 80 - 99% = 0
  1821.  
  1822.  
  1823. PARAMS (138)
  1824. Primary pointer page: 272, Index root page: 273
  1825. Pointer pages: 2, data page slots: 1552
  1826. Data pages: 1552, average fill: 84%
  1827. Primary pages: 1551, secondary pages: 1, swept pages: 1548
  1828. Empty pages: 2, full pages: 1549
  1829. Fill distribution:
  1830. 0 - 19% = 2
  1831. 20 - 39% = 0
  1832. 40 - 59% = 1
  1833. 60 - 79% = 0
  1834. 80 - 99% = 1549
  1835.  
  1836.  
  1837. Index PK_PARAMS (0)
  1838. Root page: 17864, depth: 2, leaf buckets: 50, nodes: 39466
  1839. Average node length: 5.00, total dup: 0, max dup: 0
  1840. Average key length: 3.01, compression ratio: 1.26
  1841. Average prefix length: 2.78, average data length: 1.00
  1842. Clustering factor: 1576, ratio: 0.04
  1843. Fill distribution:
  1844. 0 - 19% = 1
  1845. 20 - 39% = 0
  1846. 40 - 59% = 0
  1847. 60 - 79% = 0
  1848. 80 - 99% = 49
  1849.  
  1850.  
  1851. PRODUITS_COMMANDE (145)
  1852. Primary pointer page: 286, Index root page: 287
  1853. Pointer pages: 1, data page slots: 1
  1854. Data pages: 1, average fill: 9%
  1855. Primary pages: 1, secondary pages: 0, swept pages: 1
  1856. Empty pages: 0, full pages: 0
  1857. Fill distribution:
  1858. 0 - 19% = 1
  1859. 20 - 39% = 0
  1860. 40 - 59% = 0
  1861. 60 - 79% = 0
  1862. 80 - 99% = 0
  1863.  
  1864.  
  1865. Index FK_PRODUITS_COMMANDE_1 (1)
  1866. Root page: 18605, depth: 1, leaf buckets: 1, nodes: 4
  1867. Average node length: 4.00, total dup: 2, max dup: 2
  1868. Average key length: 2.50, compression ratio: 0.50
  1869. Average prefix length: 0.50, average data length: 0.75
  1870. Clustering factor: 1, ratio: 0.25
  1871. Fill distribution:
  1872. 0 - 19% = 1
  1873. 20 - 39% = 0
  1874. 40 - 59% = 0
  1875. 60 - 79% = 0
  1876. 80 - 99% = 0
  1877.  
  1878.  
  1879. Index PK_PRODUITS_COMMANDE_1 (0)
  1880. Root page: 17670, depth: 1, leaf buckets: 1, nodes: 4
  1881. Average node length: 5.00, total dup: 0, max dup: 0
  1882. Average key length: 3.50, compression ratio: 0.57
  1883. Average prefix length: 0.50, average data length: 1.50
  1884. Clustering factor: 1, ratio: 0.25
  1885. Fill distribution:
  1886. 0 - 19% = 1
  1887. 20 - 39% = 0
  1888. 40 - 59% = 0
  1889. 60 - 79% = 0
  1890. 80 - 99% = 0
  1891.  
  1892.  
  1893. RAPPELS (149)
  1894. Primary pointer page: 294, Index root page: 295
  1895. Pointer pages: 1, data page slots: 2
  1896. Data pages: 2, average fill: 50%
  1897. Primary pages: 1, secondary pages: 1, swept pages: 1
  1898. Empty pages: 0, full pages: 0
  1899. Fill distribution:
  1900. 0 - 19% = 0
  1901. 20 - 39% = 0
  1902. 40 - 59% = 2
  1903. 60 - 79% = 0
  1904. 80 - 99% = 0
  1905.  
  1906.  
  1907. Index PK_RAPPELS (0)
  1908. Root page: 17607, depth: 1, leaf buckets: 1, nodes: 26
  1909. Average node length: 4.35, total dup: 0, max dup: 0
  1910. Average key length: 3.31, compression ratio: 0.85
  1911. Average prefix length: 1.62, average data length: 1.19
  1912. Clustering factor: 1, ratio: 0.04
  1913. Fill distribution:
  1914. 0 - 19% = 1
  1915. 20 - 39% = 0
  1916. 40 - 59% = 0
  1917. 60 - 79% = 0
  1918. 80 - 99% = 0
  1919.  
  1920.  
  1921. RELANCES (136)
  1922. Primary pointer page: 268, Index root page: 269
  1923. Pointer pages: 1, data page slots: 144
  1924. Data pages: 144, average fill: 80%
  1925. Primary pages: 143, secondary pages: 1, swept pages: 95
  1926. Empty pages: 2, full pages: 140
  1927. Fill distribution:
  1928. 0 - 19% = 3
  1929. 20 - 39% = 0
  1930. 40 - 59% = 1
  1931. 60 - 79% = 20
  1932. 80 - 99% = 120
  1933.  
  1934.  
  1935. Index FK_RELANCES_1 (1)
  1936. Root page: 18561, depth: 2, leaf buckets: 7, nodes: 4396
  1937. Average node length: 4.48, total dup: 1836, max dup: 4
  1938. Average key length: 2.61, compression ratio: 1.14
  1939. Average prefix length: 2.38, average data length: 0.60
  1940. Clustering factor: 3502, ratio: 0.80
  1941. Fill distribution:
  1942. 0 - 19% = 0
  1943. 20 - 39% = 0
  1944. 40 - 59% = 4
  1945. 60 - 79% = 0
  1946. 80 - 99% = 3
  1947.  
  1948.  
  1949. Index PK_RELANCE (0)
  1950. Root page: 17971, depth: 2, leaf buckets: 6, nodes: 4396
  1951. Average node length: 4.88, total dup: 0, max dup: 0
  1952. Average key length: 3.01, compression ratio: 0.99
  1953. Average prefix length: 1.98, average data length: 1.00
  1954. Clustering factor: 742, ratio: 0.17
  1955. Fill distribution:
  1956. 0 - 19% = 0
  1957. 20 - 39% = 1
  1958. 40 - 59% = 0
  1959. 60 - 79% = 0
  1960. 80 - 99% = 5
  1961.  
  1962.  
  1963. REMISES (147)
  1964. Primary pointer page: 290, Index root page: 291
  1965. Pointer pages: 1, data page slots: 3
  1966. Data pages: 3, average fill: 62%
  1967. Primary pages: 3, secondary pages: 0, swept pages: 3
  1968. Empty pages: 0, full pages: 2
  1969. Fill distribution:
  1970. 0 - 19% = 0
  1971. 20 - 39% = 0
  1972. 40 - 59% = 0
  1973. 60 - 79% = 3
  1974. 80 - 99% = 0
  1975.  
  1976.  
  1977. Index PK_REMISES (0)
  1978. Root page: 17666, depth: 1, leaf buckets: 1, nodes: 195
  1979. Average node length: 4.01, total dup: 0, max dup: 0
  1980. Average key length: 3.00, compression ratio: 0.88
  1981. Average prefix length: 1.63, average data length: 1.01
  1982. Clustering factor: 3, ratio: 0.02
  1983. Fill distribution:
  1984. 0 - 19% = 1
  1985. 20 - 39% = 0
  1986. 40 - 59% = 0
  1987. 60 - 79% = 0
  1988. 80 - 99% = 0
  1989.  
  1990.  
  1991. TARIFS (132)
  1992. Primary pointer page: 260, Index root page: 261
  1993. Pointer pages: 1, data page slots: 80
  1994. Data pages: 80, average fill: 87%
  1995. Primary pages: 79, secondary pages: 1, swept pages: 24
  1996. Empty pages: 1, full pages: 77
  1997. Fill distribution:
  1998. 0 - 19% = 1
  1999. 20 - 39% = 0
  2000. 40 - 59% = 1
  2001. 60 - 79% = 1
  2002. 80 - 99% = 77
  2003.  
  2004.  
  2005. Index PK_TARIFS (0)
  2006. Root page: 18148, depth: 2, leaf buckets: 2, nodes: 1594
  2007. Average node length: 4.77, total dup: 0, max dup: 0
  2008. Average key length: 3.01, compression ratio: 0.97
  2009. Average prefix length: 1.92, average data length: 1.01
  2010. Clustering factor: 326, ratio: 0.20
  2011. Fill distribution:
  2012. 0 - 19% = 0
  2013. 20 - 39% = 0
  2014. 40 - 59% = 0
  2015. 60 - 79% = 0
  2016. 80 - 99% = 2
  2017.  
  2018.  
  2019. TEXTES (135)
  2020. Primary pointer page: 266, Index root page: 267
  2021. Pointer pages: 1, data page slots: 7
  2022. Data pages: 7, average fill: 75%
  2023. Primary pages: 2, secondary pages: 5, swept pages: 0
  2024. Empty pages: 0, full pages: 5
  2025. Fill distribution:
  2026. 0 - 19% = 0
  2027. 20 - 39% = 1
  2028. 40 - 59% = 1
  2029. 60 - 79% = 0
  2030. 80 - 99% = 5
  2031.  
  2032.  
  2033. Index PK_TEXTES (0)
  2034. Root page: 17976, depth: 1, leaf buckets: 1, nodes: 39
  2035. Average node length: 4.05, total dup: 0, max dup: 0
  2036. Average key length: 3.00, compression ratio: 0.71
  2037. Average prefix length: 1.10, average data length: 1.03
  2038. Clustering factor: 2, ratio: 0.05
  2039. Fill distribution:
  2040. 0 - 19% = 1
  2041. 20 - 39% = 0
  2042. 40 - 59% = 0
  2043. 60 - 79% = 0
  2044. 80 - 99% = 0
  2045.  
  2046.  
  2047. USERS (139)
  2048. Primary pointer page: 274, Index root page: 275
  2049. Pointer pages: 1, data page slots: 1
  2050. Data pages: 1, average fill: 49%
  2051. Primary pages: 1, secondary pages: 0, swept pages: 1
  2052. Empty pages: 0, full pages: 0
  2053. Fill distribution:
  2054. 0 - 19% = 0
  2055. 20 - 39% = 0
  2056. 40 - 59% = 1
  2057. 60 - 79% = 0
  2058. 80 - 99% = 0
  2059.  
  2060.  
  2061. Index PK_USER (0)
  2062. Root page: 17861, depth: 1, leaf buckets: 1, nodes: 11
  2063. Average node length: 4.18, total dup: 0, max dup: 0
  2064. Average key length: 3.00, compression ratio: 0.64
  2065. Average prefix length: 0.82, average data length: 1.09
  2066. Clustering factor: 1, ratio: 0.09
  2067. Fill distribution:
  2068. 0 - 19% = 1
  2069. 20 - 39% = 0
  2070. 40 - 59% = 0
  2071. 60 - 79% = 0
  2072. 80 - 99% = 0
  2073.  
  2074.  
  2075. Gstat completion time Fri Jan 17 13:24:01 2020
  2076. [/code]
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!