ORACLE 双谓词基数计算

最新推荐文章于 2021-04-03 19:02:51 发布

好难取名

最新推荐文章于 2021-04-03 19:02:51 发布

阅读量596

点赞数

文章标签： ORACLE 基数

本文链接：https://blog.csdn.net/xg_87/article/details/53909425

版权

oracle版本11.2.0.4.0 - 64bit

原始sql：

SELECT /*+parallel(0)*/ /*+dynamic_sampling(T 0)*/ COUNT(*)

FROM REPORT.MID_SAP_REAL_DATA T
WHERE "T"."TRANSACTION_DATE" >=
TO_DATE(' 2016-11-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss')
and NVL(T.KNDNR,0) <> 'M1100816'

TRACLE :

SINGLE TABLE ACCESS PATH
Single Table Cardinality Estimation for MID_SAP_REAL_DATA[T]

Column (#65):
NewDensity:0.002243, OldDensity:0.003398 BktCnt:254, PopBktCnt:50, PopValCnt:25, NDV:383
Column (#65): TRANSACTION_DATE(
AvgLen: 8 NDV: 383 Nulls: 0 Density: 0.002243 Min: 2457054 Max: 2457748
Histogram: HtBal #Bkts: 254 UncompBkts: 254 EndPtVals: 229
Column (#6):
NewDensity:0.000051, OldDensity:0.000410 BktCnt:254, PopBktCnt:0, PopValCnt:0, NDV:19552
Column (#6): KNDNR(
AvgLen: 11 NDV: 19552 Nulls: 12758 Density: 0.000051
Histogram: HtBal #Bkts: 254 UncompBkts: 254 EndPtVals: 255
Table: MID_SAP_REAL_DATA Alias: T
Card: Original: 17115029.000000 Rounded: 2412152 Computed: 2412152.46 Non Adjusted: 2412152.46

统计信息：

OWNER	TABLE_NAME	COLUMN_NAME	ENDPOINT_NUMBER	ENDPOINT_VALUE	ENDPOINT_VALUE2	ENDPOINT_ACTUAL_VALUE
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	1	2457054	2015-01-31 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	2	2457082	2015-02-28 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	3	2457113	2015-03-31 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	5	2457143	2015-04-30 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	6	2457174	2015-05-31 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	7	2457204	2015-06-30 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	8	2457235	2015-07-31 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	9	2457266	2015-08-31 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	11	2457296	2015-09-30 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	12	2457327	2015-10-31 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	13	2457357	2015-11-30 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	14	2457368	2015-12-11 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	15	2457374	2015-12-17 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	17	2457378	2015-12-21 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	18	2457380	2015-12-23 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	19	2457381	2015-12-24 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	21	2457382	2015-12-25 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	22	2457383	2015-12-26 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	23	2457384	2015-12-27 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	25	2457385	2015-12-28 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	27	2457386	2015-12-29 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	28	2457387	2015-12-30 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	30	2457388	2015-12-31 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	31	2457392	2016-01-04 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	32	2457395	2016-01-07 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	33	2457397	2016-01-09 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	34	2457398	2016-01-10 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	35	2457400	2016-01-12 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	36	2457401	2016-01-13 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	37	2457402	2016-01-14 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	38	2457404	2016-01-16 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	39	2457405	2016-01-17 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	40	2457406	2016-01-18 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	42	2457407	2016-01-19 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	43	2457408	2016-01-20 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	44	2457409	2016-01-21 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	45	2457410	2016-01-22 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	47	2457411	2016-01-23 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	48	2457412	2016-01-24 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	50	2457413	2016-01-25 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	51	2457414	2016-01-26 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	53	2457415	2016-01-27 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	54	2457416	2016-01-28 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	56	2457417	2016-01-29 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	58	2457418	2016-01-30 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	60	2457419	2016-01-31 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	61	2457427	2016-02-08 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	62	2457434	2016-02-15 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	63	2457439	2016-02-20 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	64	2457442	2016-02-23 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	65	2457445	2016-02-26 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	66	2457447	2016-02-28 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	67	2457448	2016-02-29 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	68	2457454	2016-03-06 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	69	2457457	2016-03-09 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	70	2457459	2016-03-11 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	71	2457461	2016-03-13 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	72	2457463	2016-03-15 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	73	2457464	2016-03-16 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	74	2457465	2016-03-17 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	75	2457467	2016-03-19 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	76	2457468	2016-03-20 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	77	2457469	2016-03-21 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	78	2457470	2016-03-22 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	79	2457471	2016-03-23 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	80	2457472	2016-03-24 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	81	2457473	2016-03-25 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	82	2457474	2016-03-26 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	84	2457475	2016-03-27 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	85	2457476	2016-03-28 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	86	2457477	2016-03-29 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	87	2457478	2016-03-30 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	89	2457479	2016-03-31 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	90	2457486	2016-04-07 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	91	2457489	2016-04-10 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	92	2457491	2016-04-12 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	93	2457493	2016-04-14 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	94	2457495	2016-04-16 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	95	2457496	2016-04-17 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	96	2457498	2016-04-19 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	97	2457499	2016-04-20 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	98	2457500	2016-04-21 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	99	2457501	2016-04-22 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	100	2457502	2016-04-23 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	102	2457504	2016-04-25 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	103	2457505	2016-04-26 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	104	2457506	2016-04-27 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	105	2457507	2016-04-28 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	106	2457508	2016-04-29 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	108	2457509	2016-04-30 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	109	2457520	2016-05-11 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	110	2457525	2016-05-16 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	111	2457527	2016-05-18 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	112	2457528	2016-05-19 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	113	2457530	2016-05-21 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	114	2457531	2016-05-22 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	115	2457533	2016-05-24 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	116	2457534	2016-05-25 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	117	2457535	2016-05-26 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	118	2457536	2016-05-27 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	119	2457537	2016-05-28 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	120	2457538	2016-05-29 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	121	2457539	2016-05-30 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	122	2457540	2016-05-31 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	123	2457544	2016-06-04 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	124	2457548	2016-06-08 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	125	2457551	2016-06-11 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	126	2457554	2016-06-14 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	127	2457556	2016-06-16 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	128	2457558	2016-06-18 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	129	2457560	2016-06-20 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	130	2457561	2016-06-21 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	131	2457562	2016-06-22 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	132	2457564	2016-06-24 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	133	2457565	2016-06-25 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	134	2457566	2016-06-26 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	135	2457567	2016-06-27 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	136	2457568	2016-06-28 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	137	2457569	2016-06-29 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	138	2457570	2016-06-30 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	139	2457573	2016-07-03 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	140	2457578	2016-07-08 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	141	2457581	2016-07-11 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	142	2457584	2016-07-14 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	143	2457586	2016-07-16 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	144	2457588	2016-07-18 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	145	2457589	2016-07-19 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	146	2457590	2016-07-20 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	147	2457592	2016-07-22 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	148	2457593	2016-07-23 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	149	2457594	2016-07-24 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	150	2457595	2016-07-25 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	151	2457596	2016-07-26 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	152	2457597	2016-07-27 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	153	2457598	2016-07-28 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	154	2457599	2016-07-29 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	155	2457600	2016-07-30 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	156	2457601	2016-07-31 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	157	2457605	2016-08-04 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	158	2457609	2016-08-08 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	159	2457611	2016-08-10 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	160	2457613	2016-08-12 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	161	2457615	2016-08-14 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	162	2457617	2016-08-16 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	163	2457618	2016-08-17 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	164	2457619	2016-08-18 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	165	2457620	2016-08-19 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	166	2457622	2016-08-21 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	167	2457623	2016-08-22 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	168	2457624	2016-08-23 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	169	2457625	2016-08-24 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	170	2457626	2016-08-25 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	172	2457627	2016-08-26 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	173	2457628	2016-08-27 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	174	2457629	2016-08-28 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	175	2457630	2016-08-29 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	176	2457631	2016-08-30 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	178	2457632	2016-08-31 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	179	2457637	2016-09-05 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	180	2457640	2016-09-08 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	181	2457642	2016-09-10 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	182	2457644	2016-09-12 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	183	2457645	2016-09-13 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	184	2457647	2016-09-15 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	185	2457648	2016-09-16 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	186	2457649	2016-09-17 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	187	2457651	2016-09-19 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	188	2457652	2016-09-20 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	189	2457653	2016-09-21 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	190	2457654	2016-09-22 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	191	2457655	2016-09-23 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	192	2457656	2016-09-24 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	193	2457657	2016-09-25 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	195	2457658	2016-09-26 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	196	2457659	2016-09-27 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	197	2457660	2016-09-28 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	199	2457661	2016-09-29 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	200	2457662	2016-09-30 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	201	2457672	2016-10-10 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	202	2457674	2016-10-12 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	203	2457676	2016-10-14 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	204	2457678	2016-10-16 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	205	2457679	2016-10-17 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	206	2457681	2016-10-19 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	207	2457682	2016-10-20 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	208	2457683	2016-10-21 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	209	2457685	2016-10-23 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	210	2457686	2016-10-24 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	211	2457687	2016-10-25 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	212	2457688	2016-10-26 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	213	2457689	2016-10-27 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	214	2457690	2016-10-28 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	215	2457691	2016-10-29 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	217	2457692	2016-10-30 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	218	2457693	2016-10-31 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	219	2457698	2016-11-05 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	220	2457701	2016-11-08 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	221	2457703	2016-11-10 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	222	2457705	2016-11-12 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	223	2457707	2016-11-14 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	224	2457709	2016-11-16 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	225	2457710	2016-11-17 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	226	2457711	2016-11-18 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	227	2457713	2016-11-20 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	228	2457714	2016-11-21 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	229	2457715	2016-11-22 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	230	2457716	2016-11-23 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	231	2457717	2016-11-24 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	232	2457718	2016-11-25 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	233	2457719	2016-11-26 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	234	2457720	2016-11-27 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	235	2457721	2016-11-28 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	237	2457722	2016-11-29 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	238	2457723	2016-11-30 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	239	2457727	2016-12-04 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	240	2457730	2016-12-07 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	241	2457733	2016-12-10 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	242	2457735	2016-12-12 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	243	2457736	2016-12-13 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	244	2457738	2016-12-15 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	245	2457739	2016-12-16 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	246	2457741	2016-12-18 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	247	2457742	2016-12-19 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	248	2457743	2016-12-20 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	249	2457744	2016-12-21 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	250	2457745	2016-12-22 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	251	2457746	2016-12-23 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	252	2457747	2016-12-24 00:00:00
REPORT	MID_SAP_REAL_DATA	TRANSACTION_DATE	254	2457748	2016-12-25 00:00:00

OWNER	TABLE_NAME	COLUMN_NAME	ENDPOINT_NUMBER	ENDPOINT_VALUE	ENDPOINT_ACTUAL_VALUE
REPORT	MID_SAP_REAL_DATA	KNDNR	165	2.50208E+35	0001233177
REPORT	MID_SAP_REAL_DATA	KNDNR	166	2.50208E+35	0001233216
REPORT	MID_SAP_REAL_DATA	KNDNR	167	2.50208E+35	0001233293
REPORT	MID_SAP_REAL_DATA	KNDNR	168	2.50208E+35	0001233308
REPORT	MID_SAP_REAL_DATA	KNDNR	169	2.50208E+35	0001233522
REPORT	MID_SAP_REAL_DATA	KNDNR	170	2.50208E+35	0001233803
REPORT	MID_SAP_REAL_DATA	KNDNR	171	2.50208E+35	0001234138
REPORT	MID_SAP_REAL_DATA	KNDNR	172	2.50208E+35	0001234207
REPORT	MID_SAP_REAL_DATA	KNDNR	173	2.50208E+35	0001234313
REPORT	MID_SAP_REAL_DATA	KNDNR	174	2.50208E+35	0001234505
REPORT	MID_SAP_REAL_DATA	KNDNR	175	2.50208E+35	0001234595
REPORT	MID_SAP_REAL_DATA	KNDNR	176	2.50208E+35	0001234681
REPORT	MID_SAP_REAL_DATA	KNDNR	177	2.50208E+35	0001234752
REPORT	MID_SAP_REAL_DATA	KNDNR	178	2.50208E+35	0001234825
REPORT	MID_SAP_REAL_DATA	KNDNR	179	2.50208E+35	0001234887
REPORT	MID_SAP_REAL_DATA	KNDNR	180	2.50208E+35	0001234979
REPORT	MID_SAP_REAL_DATA	KNDNR	181	2.50208E+35	0001235090
REPORT	MID_SAP_REAL_DATA	KNDNR	182	2.50208E+35	0001235175
REPORT	MID_SAP_REAL_DATA	KNDNR	183	2.50208E+35	0001235275
REPORT	MID_SAP_REAL_DATA	KNDNR	184	2.50208E+35	0001235330
REPORT	MID_SAP_REAL_DATA	KNDNR	185	2.50208E+35	0001235474
REPORT	MID_SAP_REAL_DATA	KNDNR	186	2.50208E+35	0001235607
REPORT	MID_SAP_REAL_DATA	KNDNR	187	2.50208E+35	0001235700
REPORT	MID_SAP_REAL_DATA	KNDNR	188	2.50208E+35	0001235962
REPORT	MID_SAP_REAL_DATA	KNDNR	189	2.50208E+35	0001235997
REPORT	MID_SAP_REAL_DATA	KNDNR	190	2.50208E+35	0001236030
REPORT	MID_SAP_REAL_DATA	KNDNR	191	2.50208E+35	0001236068
REPORT	MID_SAP_REAL_DATA	KNDNR	192	2.50208E+35	0001236104
REPORT	MID_SAP_REAL_DATA	KNDNR	193	2.50208E+35	0001236350
REPORT	MID_SAP_REAL_DATA	KNDNR	194	2.50208E+35	0001236434
REPORT	MID_SAP_REAL_DATA	KNDNR	195	2.50208E+35	0001236515
REPORT	MID_SAP_REAL_DATA	KNDNR	196	2.50208E+35	0001236596
REPORT	MID_SAP_REAL_DATA	KNDNR	197	2.50208E+35	0001236698
REPORT	MID_SAP_REAL_DATA	KNDNR	198	2.50208E+35	0001236970
REPORT	MID_SAP_REAL_DATA	KNDNR	199	2.50208E+35	0001237216
REPORT	MID_SAP_REAL_DATA	KNDNR	200	2.50208E+35	0001237406
REPORT	MID_SAP_REAL_DATA	KNDNR	201	2.50208E+35	0001237515
REPORT	MID_SAP_REAL_DATA	KNDNR	202	2.50208E+35	0001237770
REPORT	MID_SAP_REAL_DATA	KNDNR	203	2.50208E+35	0001238727
REPORT	MID_SAP_REAL_DATA	KNDNR	204	2.50208E+35	0001238906
REPORT	MID_SAP_REAL_DATA	KNDNR	205	2.50208E+35	0001238978
REPORT	MID_SAP_REAL_DATA	KNDNR	206	2.50208E+35	0001239007
REPORT	MID_SAP_REAL_DATA	KNDNR	207	2.50208E+35	0001239017
REPORT	MID_SAP_REAL_DATA	KNDNR	208	2.50208E+35	0001239054
REPORT	MID_SAP_REAL_DATA	KNDNR	209	2.50208E+35	0001239086
REPORT	MID_SAP_REAL_DATA	KNDNR	210	2.50208E+35	0001239106
REPORT	MID_SAP_REAL_DATA	KNDNR	211	2.50208E+35	0001239154
REPORT	MID_SAP_REAL_DATA	KNDNR	212	2.50208E+35	0001239367
REPORT	MID_SAP_REAL_DATA	KNDNR	213	2.50208E+35	0001239545
REPORT	MID_SAP_REAL_DATA	KNDNR	214	2.50208E+35	0001239702
REPORT	MID_SAP_REAL_DATA	KNDNR	215	2.50208E+35	0001239803
REPORT	MID_SAP_REAL_DATA	KNDNR	216	2.50208E+35	0001239916
REPORT	MID_SAP_REAL_DATA	KNDNR	217	2.50208E+35	0001240027
REPORT	MID_SAP_REAL_DATA	KNDNR	218	2.50208E+35	0001240352
REPORT	MID_SAP_REAL_DATA	KNDNR	219	2.50208E+35	0001240520
REPORT	MID_SAP_REAL_DATA	KNDNR	220	2.50208E+35	0001240751
REPORT	MID_SAP_REAL_DATA	KNDNR	221	2.50208E+35	0001241065
REPORT	MID_SAP_REAL_DATA	KNDNR	222	2.50208E+35	0001241176
REPORT	MID_SAP_REAL_DATA	KNDNR	223	2.50208E+35	0001241285
REPORT	MID_SAP_REAL_DATA	KNDNR	224	2.50208E+35	0001241391
REPORT	MID_SAP_REAL_DATA	KNDNR	225	2.50208E+35	0001241571
REPORT	MID_SAP_REAL_DATA	KNDNR	226	2.50208E+35	0001241778
REPORT	MID_SAP_REAL_DATA	KNDNR	227	2.50208E+35	0001241955
REPORT	MID_SAP_REAL_DATA	KNDNR	228	2.50208E+35	0001242091
REPORT	MID_SAP_REAL_DATA	KNDNR	229	2.50208E+35	0001242342
REPORT	MID_SAP_REAL_DATA	KNDNR	230	2.50208E+35	0001244703
REPORT	MID_SAP_REAL_DATA	KNDNR	231	2.50208E+35	0001245011
REPORT	MID_SAP_REAL_DATA	KNDNR	232	2.50208E+35	0001245411
REPORT	MID_SAP_REAL_DATA	KNDNR	233	2.50208E+35	0001245796
REPORT	MID_SAP_REAL_DATA	KNDNR	234	2.50208E+35	0001246035
REPORT	MID_SAP_REAL_DATA	KNDNR	235	2.50208E+35	0001246558
REPORT	MID_SAP_REAL_DATA	KNDNR	236	2.50208E+35	0001248685
REPORT	MID_SAP_REAL_DATA	KNDNR	237	2.50208E+35	0001249327
REPORT	MID_SAP_REAL_DATA	KNDNR	238	2.50208E+35	0001249871
REPORT	MID_SAP_REAL_DATA	KNDNR	239	2.50208E+35	0001250466
REPORT	MID_SAP_REAL_DATA	KNDNR	240	2.50208E+35	0001251470
REPORT	MID_SAP_REAL_DATA	KNDNR	241	3.95612E+35	L1120706A8
REPORT	MID_SAP_REAL_DATA	KNDNR	242	3.95612E+35	L1160531A4
REPORT	MID_SAP_REAL_DATA	KNDNR	243	4.00805E+35	M1047691
REPORT	MID_SAP_REAL_DATA	KNDNR	244	4.00805E+35	M10476A2
REPORT	MID_SAP_REAL_DATA	KNDNR	245	4.00805E+35	M10476B0
REPORT	MID_SAP_REAL_DATA	KNDNR	246	4.00805E+35	M10476B2
REPORT	MID_SAP_REAL_DATA	KNDNR	247	4.00805E+35	M10476C1
REPORT	MID_SAP_REAL_DATA	KNDNR	248	4.00805E+35	M10476C4
REPORT	MID_SAP_REAL_DATA	KNDNR	249	4.00805E+35	M10476D1
REPORT	MID_SAP_REAL_DATA	KNDNR	250	4.00805E+35	M10476D3
REPORT	MID_SAP_REAL_DATA	KNDNR	251	4.00805E+35	M10476D5
REPORT	MID_SAP_REAL_DATA	KNDNR	252	4.00805E+35	M10476F0
REPORT	MID_SAP_REAL_DATA	KNDNR	253	4.00805E+35	M10476F3
REPORT	MID_SAP_REAL_DATA	KNDNR	254	4.16747E+35	PC1013
REPORT	MID_SAP_REAL_DATA	KNDNR	0	2.50208E+35	0001200344
REPORT	MID_SAP_REAL_DATA	KNDNR	1	2.50208E+35	0001200418
REPORT	MID_SAP_REAL_DATA	KNDNR	2	2.50208E+35	0001200449
REPORT	MID_SAP_REAL_DATA	KNDNR	3	2.50208E+35	0001200501
REPORT	MID_SAP_REAL_DATA	KNDNR	4	2.50208E+35	0001200550
REPORT	MID_SAP_REAL_DATA	KNDNR	5	2.50208E+35	0001200577
REPORT	MID_SAP_REAL_DATA	KNDNR	6	2.50208E+35	0001200629
REPORT	MID_SAP_REAL_DATA	KNDNR	7	2.50208E+35	0001200727
REPORT	MID_SAP_REAL_DATA	KNDNR	8	2.50208E+35	0001200839
REPORT	MID_SAP_REAL_DATA	KNDNR	9	2.50208E+35	0001200943
REPORT	MID_SAP_REAL_DATA	KNDNR	10	2.50208E+35	0001201032
REPORT	MID_SAP_REAL_DATA	KNDNR	11	2.50208E+35	0001201422
REPORT	MID_SAP_REAL_DATA	KNDNR	12	2.50208E+35	0001201547
REPORT	MID_SAP_REAL_DATA	KNDNR	13	2.50208E+35	0001201619
REPORT	MID_SAP_REAL_DATA	KNDNR	14	2.50208E+35	0001201681
REPORT	MID_SAP_REAL_DATA	KNDNR	15	2.50208E+35	0001201766
REPORT	MID_SAP_REAL_DATA	KNDNR	16	2.50208E+35	0001201859
REPORT	MID_SAP_REAL_DATA	KNDNR	17	2.50208E+35	0001201922
REPORT	MID_SAP_REAL_DATA	KNDNR	18	2.50208E+35	0001202044
REPORT	MID_SAP_REAL_DATA	KNDNR	19	2.50208E+35	0001202108
REPORT	MID_SAP_REAL_DATA	KNDNR	20	2.50208E+35	0001202187
REPORT	MID_SAP_REAL_DATA	KNDNR	21	2.50208E+35	0001202265
REPORT	MID_SAP_REAL_DATA	KNDNR	22	2.50208E+35	0001202368
REPORT	MID_SAP_REAL_DATA	KNDNR	23	2.50208E+35	0001202499
REPORT	MID_SAP_REAL_DATA	KNDNR	24	2.50208E+35	0001202586
REPORT	MID_SAP_REAL_DATA	KNDNR	25	2.50208E+35	0001202655
REPORT	MID_SAP_REAL_DATA	KNDNR	26	2.50208E+35	0001202705
REPORT	MID_SAP_REAL_DATA	KNDNR	27	2.50208E+35	0001202753
REPORT	MID_SAP_REAL_DATA	KNDNR	28	2.50208E+35	0001202835
REPORT	MID_SAP_REAL_DATA	KNDNR	29	2.50208E+35	0001202884
REPORT	MID_SAP_REAL_DATA	KNDNR	30	2.50208E+35	0001202944
REPORT	MID_SAP_REAL_DATA	KNDNR	31	2.50208E+35	0001202991
REPORT	MID_SAP_REAL_DATA	KNDNR	32	2.50208E+35	0001203058
REPORT	MID_SAP_REAL_DATA	KNDNR	33	2.50208E+35	0001203126
REPORT	MID_SAP_REAL_DATA	KNDNR	34	2.50208E+35	0001203208
REPORT	MID_SAP_REAL_DATA	KNDNR	35	2.50208E+35	0001203285
REPORT	MID_SAP_REAL_DATA	KNDNR	36	2.50208E+35	0001203358
REPORT	MID_SAP_REAL_DATA	KNDNR	37	2.50208E+35	0001203462
REPORT	MID_SAP_REAL_DATA	KNDNR	38	2.50208E+35	0001203555
REPORT	MID_SAP_REAL_DATA	KNDNR	39	2.50208E+35	0001203650
REPORT	MID_SAP_REAL_DATA	KNDNR	40	2.50208E+35	0001203816
REPORT	MID_SAP_REAL_DATA	KNDNR	41	2.50208E+35	0001203900
REPORT	MID_SAP_REAL_DATA	KNDNR	42	2.50208E+35	0001203942
REPORT	MID_SAP_REAL_DATA	KNDNR	43	2.50208E+35	0001203979
REPORT	MID_SAP_REAL_DATA	KNDNR	44	2.50208E+35	0001204044
REPORT	MID_SAP_REAL_DATA	KNDNR	45	2.50208E+35	0001204127
REPORT	MID_SAP_REAL_DATA	KNDNR	46	2.50208E+35	0001204204
REPORT	MID_SAP_REAL_DATA	KNDNR	47	2.50208E+35	0001204281
REPORT	MID_SAP_REAL_DATA	KNDNR	48	2.50208E+35	0001204391
REPORT	MID_SAP_REAL_DATA	KNDNR	49	2.50208E+35	0001204505
REPORT	MID_SAP_REAL_DATA	KNDNR	50	2.50208E+35	0001204598
REPORT	MID_SAP_REAL_DATA	KNDNR	51	2.50208E+35	0001204686
REPORT	MID_SAP_REAL_DATA	KNDNR	52	2.50208E+35	0001204755
REPORT	MID_SAP_REAL_DATA	KNDNR	53	2.50208E+35	0001204811
REPORT	MID_SAP_REAL_DATA	KNDNR	54	2.50208E+35	0001204874
REPORT	MID_SAP_REAL_DATA	KNDNR	55	2.50208E+35	0001204954
REPORT	MID_SAP_REAL_DATA	KNDNR	56	2.50208E+35	0001205035
REPORT	MID_SAP_REAL_DATA	KNDNR	57	2.50208E+35	0001205119
REPORT	MID_SAP_REAL_DATA	KNDNR	58	2.50208E+35	0001205161
REPORT	MID_SAP_REAL_DATA	KNDNR	59	2.50208E+35	0001205281
REPORT	MID_SAP_REAL_DATA	KNDNR	60	2.50208E+35	0001205352
REPORT	MID_SAP_REAL_DATA	KNDNR	61	2.50208E+35	0001205414
REPORT	MID_SAP_REAL_DATA	KNDNR	62	2.50208E+35	0001205495
REPORT	MID_SAP_REAL_DATA	KNDNR	63	2.50208E+35	0001205538
REPORT	MID_SAP_REAL_DATA	KNDNR	64	2.50208E+35	0001205625
REPORT	MID_SAP_REAL_DATA	KNDNR	65	2.50208E+35	0001205693
REPORT	MID_SAP_REAL_DATA	KNDNR	66	2.50208E+35	0001205809
REPORT	MID_SAP_REAL_DATA	KNDNR	67	2.50208E+35	0001205892
REPORT	MID_SAP_REAL_DATA	KNDNR	68	2.50208E+35	0001205996
REPORT	MID_SAP_REAL_DATA	KNDNR	69	2.50208E+35	0001206069
REPORT	MID_SAP_REAL_DATA	KNDNR	70	2.50208E+35	0001206174
REPORT	MID_SAP_REAL_DATA	KNDNR	71	2.50208E+35	0001206273
REPORT	MID_SAP_REAL_DATA	KNDNR	72	2.50208E+35	0001206370
REPORT	MID_SAP_REAL_DATA	KNDNR	73	2.50208E+35	0001206468
REPORT	MID_SAP_REAL_DATA	KNDNR	74	2.50208E+35	0001206626
REPORT	MID_SAP_REAL_DATA	KNDNR	75	2.50208E+35	0001206789
REPORT	MID_SAP_REAL_DATA	KNDNR	76	2.50208E+35	0001206944
REPORT	MID_SAP_REAL_DATA	KNDNR	77	2.50208E+35	0001207052
REPORT	MID_SAP_REAL_DATA	KNDNR	78	2.50208E+35	0001207232
REPORT	MID_SAP_REAL_DATA	KNDNR	79	2.50208E+35	0001207444
REPORT	MID_SAP_REAL_DATA	KNDNR	80	2.50208E+35	0001207707
REPORT	MID_SAP_REAL_DATA	KNDNR	81	2.50208E+35	0001207922
REPORT	MID_SAP_REAL_DATA	KNDNR	82	2.50208E+35	0001208183
REPORT	MID_SAP_REAL_DATA	KNDNR	83	2.50208E+35	0001208267
REPORT	MID_SAP_REAL_DATA	KNDNR	84	2.50208E+35	0001208369
REPORT	MID_SAP_REAL_DATA	KNDNR	85	2.50208E+35	0001208688
REPORT	MID_SAP_REAL_DATA	KNDNR	86	2.50208E+35	0001208829
REPORT	MID_SAP_REAL_DATA	KNDNR	87	2.50208E+35	0001208961
REPORT	MID_SAP_REAL_DATA	KNDNR	88	2.50208E+35	0001209114
REPORT	MID_SAP_REAL_DATA	KNDNR	89	2.50208E+35	0001209237
REPORT	MID_SAP_REAL_DATA	KNDNR	90	2.50208E+35	0001209387
REPORT	MID_SAP_REAL_DATA	KNDNR	91	2.50208E+35	0001209762
REPORT	MID_SAP_REAL_DATA	KNDNR	92	2.50208E+35	0001209972
REPORT	MID_SAP_REAL_DATA	KNDNR	93	2.50208E+35	0001210201
REPORT	MID_SAP_REAL_DATA	KNDNR	94	2.50208E+35	0001210525
REPORT	MID_SAP_REAL_DATA	KNDNR	95	2.50208E+35	0001210794
REPORT	MID_SAP_REAL_DATA	KNDNR	96	2.50208E+35	0001211284
REPORT	MID_SAP_REAL_DATA	KNDNR	97	2.50208E+35	0001211460
REPORT	MID_SAP_REAL_DATA	KNDNR	98	2.50208E+35	0001211938
REPORT	MID_SAP_REAL_DATA	KNDNR	99	2.50208E+35	0001212114
REPORT	MID_SAP_REAL_DATA	KNDNR	100	2.50208E+35	0001212443
REPORT	MID_SAP_REAL_DATA	KNDNR	101	2.50208E+35	0001213248
REPORT	MID_SAP_REAL_DATA	KNDNR	102	2.50208E+35	0001213513
REPORT	MID_SAP_REAL_DATA	KNDNR	103	2.50208E+35	0001213759
REPORT	MID_SAP_REAL_DATA	KNDNR	104	2.50208E+35	0001214108
REPORT	MID_SAP_REAL_DATA	KNDNR	105	2.50208E+35	0001214427
REPORT	MID_SAP_REAL_DATA	KNDNR	106	2.50208E+35	0001214635
REPORT	MID_SAP_REAL_DATA	KNDNR	107	2.50208E+35	0001214757
REPORT	MID_SAP_REAL_DATA	KNDNR	108	2.50208E+35	0001215077
REPORT	MID_SAP_REAL_DATA	KNDNR	109	2.50208E+35	0001215393
REPORT	MID_SAP_REAL_DATA	KNDNR	110	2.50208E+35	0001215553
REPORT	MID_SAP_REAL_DATA	KNDNR	111	2.50208E+35	0001215806
REPORT	MID_SAP_REAL_DATA	KNDNR	112	2.50208E+35	0001215954
REPORT	MID_SAP_REAL_DATA	KNDNR	113	2.50208E+35	0001216186
REPORT	MID_SAP_REAL_DATA	KNDNR	114	2.50208E+35	0001216397
REPORT	MID_SAP_REAL_DATA	KNDNR	115	2.50208E+35	0001216797
REPORT	MID_SAP_REAL_DATA	KNDNR	116	2.50208E+35	0001217207
REPORT	MID_SAP_REAL_DATA	KNDNR	117	2.50208E+35	0001217440
REPORT	MID_SAP_REAL_DATA	KNDNR	118	2.50208E+35	0001217833
REPORT	MID_SAP_REAL_DATA	KNDNR	119	2.50208E+35	0001218086
REPORT	MID_SAP_REAL_DATA	KNDNR	120	2.50208E+35	0001218477
REPORT	MID_SAP_REAL_DATA	KNDNR	121	2.50208E+35	0001218740
REPORT	MID_SAP_REAL_DATA	KNDNR	122	2.50208E+35	0001218969
REPORT	MID_SAP_REAL_DATA	KNDNR	123	2.50208E+35	0001219215
REPORT	MID_SAP_REAL_DATA	KNDNR	124	2.50208E+35	0001219391
REPORT	MID_SAP_REAL_DATA	KNDNR	125	2.50208E+35	0001220216
REPORT	MID_SAP_REAL_DATA	KNDNR	126	2.50208E+35	0001221018
REPORT	MID_SAP_REAL_DATA	KNDNR	127	2.50208E+35	0001225756
REPORT	MID_SAP_REAL_DATA	KNDNR	128	2.50208E+35	0001226077
REPORT	MID_SAP_REAL_DATA	KNDNR	129	2.50208E+35	0001226493
REPORT	MID_SAP_REAL_DATA	KNDNR	130	2.50208E+35	0001226936
REPORT	MID_SAP_REAL_DATA	KNDNR	131	2.50208E+35	0001227475
REPORT	MID_SAP_REAL_DATA	KNDNR	132	2.50208E+35	0001228027
REPORT	MID_SAP_REAL_DATA	KNDNR	133	2.50208E+35	0001228558
REPORT	MID_SAP_REAL_DATA	KNDNR	134	2.50208E+35	0001228791
REPORT	MID_SAP_REAL_DATA	KNDNR	135	2.50208E+35	0001228966
REPORT	MID_SAP_REAL_DATA	KNDNR	136	2.50208E+35	0001229277
REPORT	MID_SAP_REAL_DATA	KNDNR	137	2.50208E+35	0001229562
REPORT	MID_SAP_REAL_DATA	KNDNR	138	2.50208E+35	0001229864
REPORT	MID_SAP_REAL_DATA	KNDNR	139	2.50208E+35	0001230057
REPORT	MID_SAP_REAL_DATA	KNDNR	140	2.50208E+35	0001230405
REPORT	MID_SAP_REAL_DATA	KNDNR	141	2.50208E+35	0001230730
REPORT	MID_SAP_REAL_DATA	KNDNR	142	2.50208E+35	0001231016
REPORT	MID_SAP_REAL_DATA	KNDNR	143	2.50208E+35	0001231320
REPORT	MID_SAP_REAL_DATA	KNDNR	144	2.50208E+35	0001231483
REPORT	MID_SAP_REAL_DATA	KNDNR	145	2.50208E+35	0001231896
REPORT	MID_SAP_REAL_DATA	KNDNR	146	2.50208E+35	0001232348
REPORT	MID_SAP_REAL_DATA	KNDNR	147	2.50208E+35	0001232775
REPORT	MID_SAP_REAL_DATA	KNDNR	148	2.50208E+35	0001232970
REPORT	MID_SAP_REAL_DATA	KNDNR	149	2.50208E+35	0001232981
REPORT	MID_SAP_REAL_DATA	KNDNR	150	2.50208E+35	0001232986
REPORT	MID_SAP_REAL_DATA	KNDNR	151	2.50208E+35	0001232993
REPORT	MID_SAP_REAL_DATA	KNDNR	152	2.50208E+35	0001232994
REPORT	MID_SAP_REAL_DATA	KNDNR	153	2.50208E+35	0001233012
REPORT	MID_SAP_REAL_DATA	KNDNR	154	2.50208E+35	0001233024
REPORT	MID_SAP_REAL_DATA	KNDNR	155	2.50208E+35	0001233032
REPORT	MID_SAP_REAL_DATA	KNDNR	156	2.50208E+35	0001233051
REPORT	MID_SAP_REAL_DATA	KNDNR	157	2.50208E+35	0001233057
REPORT	MID_SAP_REAL_DATA	KNDNR	158	2.50208E+35	0001233077
REPORT	MID_SAP_REAL_DATA	KNDNR	159	2.50208E+35	0001233102
REPORT	MID_SAP_REAL_DATA	KNDNR	160	2.50208E+35	0001233116
REPORT	MID_SAP_REAL_DATA	KNDNR	161	2.50208E+35	0001233127
REPORT	MID_SAP_REAL_DATA	KNDNR	162	2.50208E+35	0001233146
REPORT	MID_SAP_REAL_DATA	KNDNR	163	2.50208E+35	0001233164
REPORT	MID_SAP_REAL_DATA	KNDNR	164	2.50208E+35	0001233167

============
Plan Table
============
------------------------------------------------------+-----------------------------------+---------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time | Pstart| Pstop |
------------------------------------------------------+-----------------------------------+---------------+
| 0 | SELECT STATEMENT | | | | 51K | | | |
| 1 | SORT AGGREGATE | | 1 | 19 | | | | |
| 2 | PARTITION RANGE ITERATOR | | 2356K | 44M | 51K | 00:10:29 | 12 | 1048575|
| 3 | TABLE ACCESS FULL | MID_SAP_REAL_DATA| 2356K | 44M | 51K | 00:10:29 | 12 | 1048575|
------------------------------------------------------+-----------------------------------+---------------+

基数计算：

((19552-1)/19552*(17115029-12758)+12758)/17115029 * (35+4/5)/254 * 17115029=2412152.45547198 ≈2412152.46

解释：

1. KNDNR 列的悬着率 0.000051 ≈ 1/19552<唯一值个数>=5.11456628477905E-5 ≈ 0.000051

NVL("T"."KNDNR",'0')<>'M1100816' 可以解释为选择除 KNDNR='M1100816' 外的记录，那么应该选中的记录数就是

（19552-1)/19552*(17115029<总记录数>-12758<KNDNR为空值条数>)+12758

2. TRANSACTION_DATE 列是范围选着且有高度均衡直方图，所以选着率的计算是

(35<完整包含的桶数>+4/5<部分包含的桶>)/254<总的桶>

疑问：Trc 文件中的 NewDensity:0.000051, OldDensity:0.000410 不一致 NewDensity oracle是如何决定的？

好难取名

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
ORACLE 双谓词基数计算

oracle版本11.2.0.4.0 - 64bit 原始sql：SELECT /*+parallel(0)*/ /*+dynamic_sampling(T 0)*/ COUNT(*) FROM REPORT.MID_SAP_REAL_DATA T WHERE "T"."TRANSACTION_DATE" >= TO_DATE(' 2016-11-01 00:
复制链接

扫一扫