Created
May 31, 2022 20:08
-
-
Save oracle9999/28e991d0069befcf7d4d77f5b8e0420a to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
On 19c Database:- | |
SAMPLE_SIZE NUM_ROWS NUM_DISTINCT | |
1022529 1022529 1019328 | |
256383588 256383588 255590400 | |
261532405 261532405 260571136 | |
263059486 263059486 263059486 | |
263621880 263621880 263621880 | |
263654284 263654284 263654284 | |
268024281 268024281 268024281 | |
269880658 269880658 269880658 | |
269893705 269893705 269893705 | |
272935690 272935690 272935690 | |
273655413 273655413 268107776 | |
275815307 275815307 275815307 | |
277763859 277763859 277763859 | |
278161060 278161060 278161060 | |
278350470 278350470 274890752 | |
278841034 278841034 278841034 | |
278997649 278997649 278997649 | |
279031234 279031234 278495232 | |
282765454 282765454 282765454 | |
284530356 284530356 282689536 | |
284619058 284619058 282656768 | |
285038738 285038738 285038738 | |
285260915 285260915 285260915 | |
285563348 285563348 283934720 | |
285906093 285906093 285906093 | |
286293645 286293645 286031872 | |
286436484 286436484 286436484 | |
286532116 286532116 285278208 | |
286851749 286851749 286851749 | |
286933276 286933276 286933276 | |
286988698 286988698 286988698 | |
287863712 287863712 286752768 | |
288005288 288005288 281477120 | |
288185608 288185608 284196864 | |
288265756 288265756 285310976 | |
288376321 288376321 287014912 | |
288380440 288380440 285736960 | |
288438479 288438479 285048832 | |
288537592 288537592 288537592 | |
288570736 288570736 288570736 | |
288621128 288621128 288621128 | |
288682586 288682586 288682586 | |
288875153 288875153 288875153 | |
289017348 289017348 287145984 | |
289172367 289172367 287670272 | |
289969346 289969346 289969346 | |
290434235 290434235 285048832 | |
290580553 290580553 290580553 | |
290629888 290629888 290629888 | |
290887639 290887639 285474816 | |
291277716 291277716 290586624 | |
291448419 291448419 291448419 | |
291806932 291806932 289996800 | |
292143639 292143639 292143639 | |
292300609 292300609 289800192 | |
292330766 292330766 292330766 | |
292346998 292346998 285900800 | |
292456893 292456893 292456893 | |
292667212 292667212 291307520 | |
292771591 292771591 292771591 | |
293026175 293026175 290226176 | |
293467597 293467597 293467597 | |
293991826 293991826 293991826 | |
294565476 294565476 293699584 | |
294700284 294700284 290488320 | |
294785399 294785399 294785399 | |
294863088 294863088 293830656 | |
294945480 294945480 291241984 | |
295195881 295195881 295195881 | |
295309538 295309538 294420480 | |
295658895 295658895 294879232 | |
295699688 295699688 290586624 | |
296071679 296071679 296071679 | |
296273314 296273314 295829504 | |
296500342 296500342 294486016 | |
296931575 296931575 293896192 | |
297121093 297121093 295567360 | |
297777191 297777191 297777191 | |
298051718 298051718 295501824 | |
298160589 298160589 296747008 | |
298529930 298529930 298529930 | |
298538312 298538312 298538312 | |
298679505 298679505 298679505 | |
300027124 300027124 299008000 | |
300226502 300226502 297566208 | |
300784281 300784281 300784281 | |
300913443 300913443 299401216 | |
300975542 300975542 295534592 | |
301913245 301913245 301913245 | |
301966657 301966657 301367296 | |
302202004 302202004 302202004 | |
302278929 302278929 298680320 | |
302447103 302447103 298156032 | |
302668592 302668592 300711936 | |
302987866 302987866 300613632 | |
303292244 303292244 303169536 | |
303467245 303467245 303467245 | |
303525021 303525021 302317568 | |
303609028 303609028 302809088 | |
303675027 303675027 303675027 | |
303791987 303791987 303791987 | |
304044223 304044223 303759360 | |
304393844 304393844 303529984 | |
304487758 304487758 304316416 | |
305086973 305086973 300187648 | |
305319260 305319260 304316416 | |
305332998 305332998 304316416 | |
305509719 305509719 304873472 | |
305713120 305713120 305397760 | |
306411436 306411436 306411436 | |
306423639 306423639 305397760 | |
306566845 306566845 304873472 | |
306807781 306807781 306807781 | |
306911782 306911782 306911782 | |
307043269 307043269 307043269 | |
307107188 307107188 304578560 | |
307176710 307176710 303595520 | |
307522254 307522254 302579712 | |
307730315 307730315 307363840 | |
307898168 307898168 307898168 | |
307905380 307905380 307905380 | |
308127785 308127785 300613632 | |
308327725 308327725 308327725 | |
309426900 309426900 309426900 | |
311119152 311119152 311119152 | |
311190455 311190455 308248576 | |
311485209 311485209 311485209 | |
311889888 311889888 311889888 | |
312358001 312358001 305233920 | |
312748543 312748543 312748543 | |
313401022 313401022 310542336 | |
313471790 313471790 313471790 | |
313505087 313505087 311689216 | |
313689039 313689039 311623680 | |
313900408 313900408 313900408 | |
314163482 314163482 314163482 | |
314164844 314164844 311918592 | |
314288478 314288478 314288478 | |
314314542 314314542 312999936 | |
314330866 314330866 306774016 | |
314526182 314526182 314526182 | |
315342785 315342785 314212352 | |
315349309 315349309 315349309 | |
315420005 315420005 315420005 | |
315559362 315559362 312967168 | |
315873655 315873655 309624832 | |
316015858 316015858 316015858 | |
316590327 316590327 316590327 | |
317059356 317059356 314867712 | |
317322931 317322931 316768256 | |
317925998 317925998 317925998 | |
318121059 318121059 318121059 | |
318165551 318165551 318165551 | |
318456776 318456776 318456776 | |
318500972 318500972 318500972 | |
320061955 320061955 317947904 | |
320224843 320224843 316932096 | |
320880784 320880784 317685760 | |
321123514 321123514 320897024 | |
321408060 321408060 321408060 | |
323082474 323082474 323082474 | |
324920001 324920001 321454080 | |
325607857 325607857 325419008 | |
326245686 326245686 324141056 | |
326566688 326566688 326566688 | |
326706510 326706510 326706510 | |
327077093 327077093 327077093 | |
327734535 327734535 324337664 | |
328566837 328566837 326303744 | |
328608748 328608748 328608748 | |
329699667 329699667 325648384 | |
329889127 329889127 329889127 | |
330978337 330978337 330978337 | |
331095706 331095706 331095706 | |
331119645 331119645 331119645 | |
331157361 331157361 331157361 | |
331552520 331552520 329777152 | |
331781941 331781941 328007680 | |
332159023 332159023 332159023 | |
332363598 332363598 331382784 | |
332536996 332536996 332536996 | |
332931340 332931340 332931340 | |
333626558 333626558 333626558 | |
333953262 333953262 333676544 | |
335143351 335143351 335143351 | |
337577726 337577726 337543168 | |
338293009 338293009 337903616 | |
338508481 338508481 338508481 | |
338612138 338612138 337870848 | |
338809805 338809805 334757888 | |
340232277 340232277 340232277 | |
340771793 340771793 340328448 | |
342371043 342371043 342371043 | |
343693074 343693074 338165760 | |
348158797 348158797 348158797 | |
349410420 349410420 349410420 | |
349429576 349429576 349339648 | |
349909287 349909287 349909287 | |
354740701 354740701 354740701 | |
355047896 355047896 351535104 | |
355251383 355251383 350060544 | |
355541632 355541632 355270656 | |
356297408 356297408 356297408 | |
356550638 356550638 356550638 | |
358044505 358044505 357793792 | |
358661211 358661211 355041280 | |
365369539 365369539 363921408 | |
366647065 366647065 363823104 | |
368354484 368354484 363331584 | |
368368793 368368793 368368793 | |
369597673 369597673 365625344 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
On 11.2 Database:- | |
SAMPLE_SIZE NUM_ROWS NUM_DISTINCT | |
230496462 230496462 230496462 | |
256383588 256383588 255590400 | |
263654284 263654284 263654284 | |
284557736 284557736 280985600 | |
286436484 286436484 286436484 | |
286851749 286851749 286851749 | |
288005288 288005288 281477120 | |
289017348 289017348 287145984 | |
292300609 292300609 289800192 | |
292330766 292330766 292330766 | |
292346998 292346998 285900800 | |
293026175 293026175 290226176 | |
293264029 293264029 292749312 | |
294549391 294549391 294549391 | |
295945899 295945899 292487168 | |
295960623 295960623 295960623 | |
296716062 296716062 294780928 | |
298160589 298160589 296747008 | |
300378701 300378701 300351488 | |
300784281 300784281 300784281 | |
301913245 301913245 301913245 | |
302447103 302447103 298156032 | |
302987866 302987866 300613632 | |
303292244 303292244 303169536 | |
303430801 303430801 303430801 | |
303609028 303609028 302809088 | |
304044223 304044223 303759360 | |
304393844 304393844 303529984 | |
305086973 305086973 300187648 | |
305713120 305713120 305397760 | |
306411436 306411436 306411436 | |
306767266 306767266 305004544 | |
306807781 306807781 306807781 | |
307043269 307043269 307043269 | |
307522254 307522254 302579712 | |
307530691 307530691 302350336 | |
307730315 307730315 307363840 | |
307905380 307905380 307905380 | |
308327725 308327725 308327725 | |
309415272 309415272 303071232 | |
309426900 309426900 309426900 | |
309898431 309898431 309898431 | |
311119152 311119152 311119152 | |
311475290 311475290 311475290 | |
311485209 311485209 311485209 | |
311643779 311643779 311643779 | |
312748543 312748543 312748543 | |
312943613 312943613 306511872 | |
313281773 313281773 313281773 | |
313285099 313285099 313285099 | |
313401022 313401022 310542336 | |
313471790 313471790 313471790 | |
313505087 313505087 311689216 | |
313689039 313689039 311623680 | |
313900408 313900408 313900408 | |
314542040 314542040 309657600 | |
314556678 314556678 314245120 | |
314722885 314722885 311820288 | |
314816882 314816882 314816882 | |
315349309 315349309 315349309 | |
315420005 315420005 315420005 | |
315559362 315559362 312967168 | |
316075758 316075758 314179584 | |
316339722 316339722 316339722 | |
316640801 316640801 316640801 | |
316960772 316960772 315981824 | |
317059356 317059356 314867712 | |
317258218 317258218 317258218 | |
317322931 317322931 316768256 | |
317408422 317408422 317408422 | |
318191614 318191614 317718528 | |
318192481 318192481 316243968 | |
318456776 318456776 318456776 | |
318484701 318484701 318484701 | |
318494197 318494197 316637184 | |
318500972 318500972 318500972 | |
318960459 318960459 318960459 | |
320061955 320061955 317947904 | |
320074653 320074653 319717376 | |
320229370 320229370 320229370 | |
320441075 320441075 316997632 | |
320880784 320880784 317685760 | |
321123514 321123514 320897024 | |
321359482 321359482 321359482 | |
321622808 321622808 320208896 | |
321679262 321679262 318275584 | |
321737368 321737368 321737368 | |
322010620 322010620 322010620 | |
322441337 322441337 317456384 | |
322573379 322573379 322573379 | |
323405484 323405484 322404352 | |
323711665 323711665 319127552 | |
323782021 323782021 323782021 | |
324389320 324389320 320110592 | |
324920001 324920001 321454080 | |
325078427 325078427 324567040 | |
325210432 325210432 321978368 | |
325422903 325422903 325422903 | |
325607857 325607857 325419008 | |
326113087 326113087 323518464 | |
326245686 326245686 324141056 | |
326540062 326540062 326540062 | |
326566688 326566688 326566688 | |
326706510 326706510 326706510 | |
327077093 327077093 327077093 | |
327087911 327087911 327087911 | |
327429012 327429012 327429012 | |
327644168 327644168 327644168 | |
327734535 327734535 324337664 | |
327861209 327861209 325779456 | |
327994818 327994818 327994818 | |
328322932 328322932 328322932 | |
328486558 328486558 328486558 | |
328566837 328566837 326303744 | |
328740411 328740411 328740411 | |
328831268 328831268 327811072 | |
329162110 329162110 329162110 | |
329697340 329697340 327614464 | |
329699667 329699667 325648384 | |
329969244 329969244 322994176 | |
330182783 330182783 330182783 | |
330195664 330195664 330195664 | |
330504397 330504397 327647232 | |
330919060 330919060 330919060 | |
330952351 330952351 330952351 | |
330978337 330978337 330978337 | |
331095706 331095706 331095706 | |
331157361 331157361 331157361 | |
331552520 331552520 329777152 | |
331781941 331781941 328007680 | |
331933483 331933483 331933483 | |
332084488 332084488 329580544 | |
332159023 332159023 332159023 | |
332536996 332536996 332536996 | |
332637035 332637035 332637035 | |
333008815 333008815 333008815 | |
333415542 333415542 333415542 | |
333575495 333575495 333575495 | |
334461022 334461022 334004224 | |
334521043 334521043 329940992 | |
334601749 334601749 334601749 | |
335004878 335004878 334692352 | |
335143351 335143351 335143351 | |
335278589 335278589 335278589 | |
335621978 335621978 335621978 | |
336917582 336917582 336917582 | |
337276063 337276063 337276063 | |
337296779 337296779 337296779 | |
337577726 337577726 337543168 | |
338293009 338293009 337903616 | |
338508481 338508481 338508481 | |
338612138 338612138 337870848 | |
339290134 339290134 338198528 | |
339761791 339761791 339761791 | |
340031745 340031745 337575936 | |
340071601 340071601 340071601 | |
340232277 340232277 340232277 | |
340686108 340686108 338493440 | |
340771793 340771793 340328448 | |
340821420 340821420 338034688 | |
340885735 340885735 339443712 | |
341073640 341073640 341073640 | |
341340659 341340659 341340659 | |
341429447 341429447 341429447 | |
342149470 342149470 339017728 | |
342169099 342169099 342169099 | |
342371043 342371043 342371043 | |
343693074 343693074 338165760 | |
343991499 343991499 343638016 | |
345142829 345142829 345142829 | |
346051323 346051323 346051323 | |
346409664 346409664 346409664 | |
346914480 346914480 343048192 | |
347091799 347091799 345931776 | |
348158797 348158797 348158797 | |
348311593 348311593 348311593 | |
348873571 348873571 347242496 | |
348985109 348985109 346619904 | |
348999101 348999101 344064000 | |
349206427 349206427 349206427 | |
349410420 349410420 349410420 | |
349429576 349429576 349339648 | |
349805861 349805861 348291072 | |
349909287 349909287 349909287 | |
350089347 350089347 348979200 | |
350566515 350566515 350566515 | |
351885067 351885067 350420992 | |
354568032 354568032 354568032 | |
354615465 354615465 353173504 | |
354740701 354740701 354740701 | |
355015265 355015265 355015265 | |
355047896 355047896 351535104 | |
355251383 355251383 350060544 | |
355541632 355541632 355270656 | |
356297408 356297408 356297408 | |
356550638 356550638 356550638 | |
358044505 358044505 357793792 | |
358661211 358661211 355041280 | |
365369539 365369539 363921408 | |
366647065 366647065 363823104 | |
367125027 367125027 367125027 | |
368354484 368354484 363331584 | |
368368793 368368793 368368793 | |
369421697 369421697 369421697 | |
369426798 369426798 368017408 | |
369597673 369597673 365625344 | |
370254876 370254876 370254876 | |
373089495 373089495 373089495 | |
375468990 375468990 374800384 | |
390052666 390052666 388792320 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 | |
0 0 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment