API tools faq
paste
Advertisement
A248

Query Execution using applicable_active

A248
Feb 15th, 2022
109
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.78 KB | None | 0 0
raw download clone embed print report
  1. sql> EXPLAIN PLAN FOR select "libertybans_applicable_active"."id", "libertybans_applicable_active"."victim_type", "libertybans_applicable_active"."victim_uuid", "libertybans_applicable_active"."victim_address", "libertybans_applicable_active"."operator", "libertybans_applicable_active"."reason", "libertybans_applicable_active"."scope", "libertybans_applicable_active"."start", "libertybans_applicable_active"."end" from "libertybans_applicable_active" where ("libertybans_applicable_active"."type" = 0 and "libertybans_applicable_active"."uuid" = '98e90094-d8c8-4149-a3fd-ff39b83f98c1' and ("libertybans_applicable_active"."end" = 0 or "libertybans_applicable_active"."end" > 1621440000)) limit 1;
  2. isDistinctSelect=[false]
  3. isGrouped=[false]
  4. isAggregated=[false]
  5. columns=[ COLUMN: PUBLIC."libertybans_applicable_active"."id" nullable
  6. COLUMN: PUBLIC."libertybans_applicable_active"."victim_type" nullable
  7. COLUMN: PUBLIC."libertybans_applicable_active"."victim_uuid" nullable
  8. COLUMN: PUBLIC."libertybans_applicable_active"."victim_address" nullable
  9. COLUMN: PUBLIC."libertybans_applicable_active"."operator" nullable
  10. COLUMN: PUBLIC."libertybans_applicable_active"."reason" nullable
  11. COLUMN: PUBLIC."libertybans_applicable_active"."scope" nullable
  12. COLUMN: PUBLIC."libertybans_applicable_active"."start" nullable
  13. COLUMN: PUBLIC."libertybans_applicable_active"."end" nullable
  14.  
  15. ]
  16. [range variable 1
  17. join type=INNER
  18. table=libertybans_applicable_active
  19. cardinality=0
  20. access=INDEX PRED
  21. join condition = [index=SYS_IDX_T_10301
  22. start conditions=[
  23. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_applicable_active"."type"
  24. ] arg_right=[
  25. VALUE = 0, TYPE = INTEGER]
  26. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_applicable_active"."uuid"
  27. ] arg_right=[
  28. VALUE = 98e90094-d8c8-4149-a3fd-ff39b83f98c1, TYPE = UUID]]
  29. other condition=[
  30. OR arg_left=[
  31. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_applicable_active"."end"
  32. ] arg_right=[
  33. VALUE = 0, TYPE = INTEGER]] arg_right=[
  34. GREATER arg_left=[ COLUMN: PUBLIC."libertybans_applicable_active"."end"
  35. ] arg_right=[
  36. VALUE = 1621440000, TYPE = INTEGER]]]
  37. ]
  38. ]]
  39. offset=[
  40. VALUE = 0, TYPE = INTEGER]
  41. limit=[
  42. VALUE = 1, TYPE = INTEGER]
  43. PARAMETERS=[]
  44. SUBQUERIES[
  45. [level=1
  46. isDistinctSelect=[false]
  47. isGrouped=[false]
  48. isAggregated=[false]
  49. columns=[ COLUMN: PUBLIC."libertybans_punishments"."id" not nullable
  50. COLUMN: PUBLIC."libertybans_punishments"."type" not nullable
  51. COLUMN: PUBLIC."libertybans_victims"."type" AS victim_type not nullable
  52. COLUMN: PUBLIC."libertybans_victims"."uuid" AS victim_uuid not nullable
  53. COLUMN: PUBLIC."libertybans_victims"."address" AS victim_address not nullable
  54. COLUMN: PUBLIC."libertybans_punishments"."operator" not nullable
  55. COLUMN: PUBLIC."libertybans_punishments"."reason" not nullable
  56. COLUMN: PUBLIC."libertybans_punishments"."scope" not nullable
  57. COLUMN: PUBLIC."libertybans_punishments"."start" not nullable
  58. COLUMN: PUBLIC."libertybans_punishments"."end" not nullable
  59.  
  60. ]
  61. [range variable 1
  62. join type=INNER
  63. table=libertybans_bans
  64. alias=thetype
  65. cardinality=17
  66. access=FULL SCAN
  67. join condition = [index=SYS_IDX_10165
  68. ]
  69. ] [range variable 2
  70. join type=INNER
  71. table=libertybans_punishments
  72. alias=puns
  73. cardinality=254
  74. access=INDEX PRED
  75. join condition = [index=libertybans_punishment_id_uniqueness
  76. start conditions=[
  77. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_punishments"."id"
  78. ] arg_right=[ COLUMN: PUBLIC."libertybans_bans"."id"
  79. ]]
  80. ]
  81. ] [range variable 3
  82. join type=INNER
  83. table=libertybans_victims
  84. alias=victims
  85. cardinality=100
  86. access=INDEX PRED
  87. join condition = [index=libertybans_victim_id_uniqueness
  88. start conditions=[
  89. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_victims"."id"
  90. ] arg_right=[ COLUMN: PUBLIC."libertybans_bans"."victim"
  91. ]]
  92. ]
  93. ] ]
  94. ]
  95. [level=1
  96. isDistinctSelect=[false]
  97. isGrouped=[false]
  98. isAggregated=[false]
  99. columns=[ COLUMN: PUBLIC."libertybans_simple_bans"."id" nullable
  100. COLUMN: PUBLIC."libertybans_simple_bans"."type" nullable
  101. COLUMN: PUBLIC."libertybans_simple_bans"."victim_type" nullable
  102. COLUMN: PUBLIC."libertybans_simple_bans"."victim_uuid" nullable
  103. COLUMN: PUBLIC."libertybans_simple_bans"."victim_address" nullable
  104. COLUMN: PUBLIC."libertybans_simple_bans"."operator" nullable
  105. COLUMN: PUBLIC."libertybans_simple_bans"."reason" nullable
  106. COLUMN: PUBLIC."libertybans_simple_bans"."scope" nullable
  107. COLUMN: PUBLIC."libertybans_simple_bans"."start" nullable
  108. COLUMN: PUBLIC."libertybans_simple_bans"."end" nullable
  109. COLUMN: PUBLIC."libertybans_addresses"."uuid" not nullable
  110. COLUMN: PUBLIC."libertybans_addresses"."address" not nullable
  111.  
  112. ]
  113. [range variable 1
  114. join type=INNER
  115. table=libertybans_simple_bans
  116. alias=puns
  117. cardinality=0
  118. access=FULL SCAN
  119. join condition = [index=SYS_IDX_10203
  120. ]
  121. ] [range variable 2
  122. join type=INNER
  123. table=libertybans_addresses
  124. alias=addrs
  125. cardinality=8959
  126. access=FULL SCAN
  127. join condition = [index=SYS_IDX_10127
  128. other condition=[
  129. OR arg_left=[
  130. OR arg_left=[
  131. AND arg_left=[
  132. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_simple_bans"."victim_type"
  133. ] arg_right=[
  134. VALUE = 0, TYPE = INTEGER]] arg_right=[
  135. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_addresses"."uuid"
  136. ] arg_right=[ COLUMN: PUBLIC."libertybans_simple_bans"."victim_uuid"
  137. ]]] arg_right=[
  138. AND arg_left=[
  139. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_simple_bans"."victim_type"
  140. ] arg_right=[
  141. VALUE = 1, TYPE = INTEGER]] arg_right=[
  142. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_addresses"."address"
  143. ] arg_right=[ COLUMN: PUBLIC."libertybans_simple_bans"."victim_address"
  144. ]]]] arg_right=[
  145. AND arg_left=[
  146. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_simple_bans"."victim_type"
  147. ] arg_right=[
  148. VALUE = 2, TYPE = INTEGER]] arg_right=[
  149. OR arg_left=[
  150. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_addresses"."uuid"
  151. ] arg_right=[ COLUMN: PUBLIC."libertybans_simple_bans"."victim_uuid"
  152. ]] arg_right=[
  153. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_addresses"."address"
  154. ] arg_right=[ COLUMN: PUBLIC."libertybans_simple_bans"."victim_address"
  155. ]]]]]
  156. ]
  157. ] ]
  158. ]
  159. [level=1
  160. isDistinctSelect=[false]
  161. isGrouped=[false]
  162. isAggregated=[false]
  163. columns=[ COLUMN: PUBLIC."libertybans_punishments"."id" not nullable
  164. COLUMN: PUBLIC."libertybans_punishments"."type" not nullable
  165. COLUMN: PUBLIC."libertybans_victims"."type" AS victim_type not nullable
  166. COLUMN: PUBLIC."libertybans_victims"."uuid" AS victim_uuid not nullable
  167. COLUMN: PUBLIC."libertybans_victims"."address" AS victim_address not nullable
  168. COLUMN: PUBLIC."libertybans_punishments"."operator" not nullable
  169. COLUMN: PUBLIC."libertybans_punishments"."reason" not nullable
  170. COLUMN: PUBLIC."libertybans_punishments"."scope" not nullable
  171. COLUMN: PUBLIC."libertybans_punishments"."start" not nullable
  172. COLUMN: PUBLIC."libertybans_punishments"."end" not nullable
  173.  
  174. ]
  175. [range variable 1
  176. join type=INNER
  177. table=libertybans_mutes
  178. alias=thetype
  179. cardinality=0
  180. access=FULL SCAN
  181. join condition = [index=SYS_IDX_10172
  182. ]
  183. ] [range variable 2
  184. join type=INNER
  185. table=libertybans_punishments
  186. alias=puns
  187. cardinality=254
  188. access=INDEX PRED
  189. join condition = [index=libertybans_punishment_id_uniqueness
  190. start conditions=[
  191. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_punishments"."id"
  192. ] arg_right=[ COLUMN: PUBLIC."libertybans_mutes"."id"
  193. ]]
  194. ]
  195. ] [range variable 3
  196. join type=INNER
  197. table=libertybans_victims
  198. alias=victims
  199. cardinality=100
  200. access=INDEX PRED
  201. join condition = [index=libertybans_victim_id_uniqueness
  202. start conditions=[
  203. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_victims"."id"
  204. ] arg_right=[ COLUMN: PUBLIC."libertybans_mutes"."victim"
  205. ]]
  206. ]
  207. ] ]
  208. ]
  209. [level=1
  210. isDistinctSelect=[false]
  211. isGrouped=[false]
  212. isAggregated=[false]
  213. columns=[ COLUMN: PUBLIC."libertybans_simple_mutes"."id" nullable
  214. COLUMN: PUBLIC."libertybans_simple_mutes"."type" nullable
  215. COLUMN: PUBLIC."libertybans_simple_mutes"."victim_type" nullable
  216. COLUMN: PUBLIC."libertybans_simple_mutes"."victim_uuid" nullable
  217. COLUMN: PUBLIC."libertybans_simple_mutes"."victim_address" nullable
  218. COLUMN: PUBLIC."libertybans_simple_mutes"."operator" nullable
  219. COLUMN: PUBLIC."libertybans_simple_mutes"."reason" nullable
  220. COLUMN: PUBLIC."libertybans_simple_mutes"."scope" nullable
  221. COLUMN: PUBLIC."libertybans_simple_mutes"."start" nullable
  222. COLUMN: PUBLIC."libertybans_simple_mutes"."end" nullable
  223. COLUMN: PUBLIC."libertybans_addresses"."uuid" not nullable
  224. COLUMN: PUBLIC."libertybans_addresses"."address" not nullable
  225.  
  226. ]
  227. [range variable 1
  228. join type=INNER
  229. table=libertybans_simple_mutes
  230. alias=puns
  231. cardinality=0
  232. access=FULL SCAN
  233. join condition = [index=SYS_IDX_10213
  234. ]
  235. ] [range variable 2
  236. join type=INNER
  237. table=libertybans_addresses
  238. alias=addrs
  239. cardinality=8959
  240. access=FULL SCAN
  241. join condition = [index=SYS_IDX_10127
  242. other condition=[
  243. OR arg_left=[
  244. OR arg_left=[
  245. AND arg_left=[
  246. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_simple_mutes"."victim_type"
  247. ] arg_right=[
  248. VALUE = 0, TYPE = INTEGER]] arg_right=[
  249. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_addresses"."uuid"
  250. ] arg_right=[ COLUMN: PUBLIC."libertybans_simple_mutes"."victim_uuid"
  251. ]]] arg_right=[
  252. AND arg_left=[
  253. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_simple_mutes"."victim_type"
  254. ] arg_right=[
  255. VALUE = 1, TYPE = INTEGER]] arg_right=[
  256. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_addresses"."address"
  257. ] arg_right=[ COLUMN: PUBLIC."libertybans_simple_mutes"."victim_address"
  258. ]]]] arg_right=[
  259. AND arg_left=[
  260. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_simple_mutes"."victim_type"
  261. ] arg_right=[
  262. VALUE = 2, TYPE = INTEGER]] arg_right=[
  263. OR arg_left=[
  264. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_addresses"."uuid"
  265. ] arg_right=[ COLUMN: PUBLIC."libertybans_simple_mutes"."victim_uuid"
  266. ]] arg_right=[
  267. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_addresses"."address"
  268. ] arg_right=[ COLUMN: PUBLIC."libertybans_simple_mutes"."victim_address"
  269. ]]]]]
  270. ]
  271. ] ]
  272. ]
  273. [level=1
  274. isDistinctSelect=[false]
  275. isGrouped=[false]
  276. isAggregated=[false]
  277. columns=[ COLUMN: PUBLIC."libertybans_punishments"."id" not nullable
  278. COLUMN: PUBLIC."libertybans_punishments"."type" not nullable
  279. COLUMN: PUBLIC."libertybans_victims"."type" AS victim_type not nullable
  280. COLUMN: PUBLIC."libertybans_victims"."uuid" AS victim_uuid not nullable
  281. COLUMN: PUBLIC."libertybans_victims"."address" AS victim_address not nullable
  282. COLUMN: PUBLIC."libertybans_punishments"."operator" not nullable
  283. COLUMN: PUBLIC."libertybans_punishments"."reason" not nullable
  284. COLUMN: PUBLIC."libertybans_punishments"."scope" not nullable
  285. COLUMN: PUBLIC."libertybans_punishments"."start" not nullable
  286. COLUMN: PUBLIC."libertybans_punishments"."end" not nullable
  287.  
  288. ]
  289. [range variable 1
  290. join type=INNER
  291. table=libertybans_warns
  292. alias=thetype
  293. cardinality=4
  294. access=FULL SCAN
  295. join condition = [index=SYS_IDX_10179
  296. ]
  297. ] [range variable 2
  298. join type=INNER
  299. table=libertybans_punishments
  300. alias=puns
  301. cardinality=254
  302. access=INDEX PRED
  303. join condition = [index=libertybans_punishment_id_uniqueness
  304. start conditions=[
  305. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_punishments"."id"
  306. ] arg_right=[ COLUMN: PUBLIC."libertybans_warns"."id"
  307. ]]
  308. ]
  309. ] [range variable 3
  310. join type=INNER
  311. table=libertybans_victims
  312. alias=victims
  313. cardinality=100
  314. access=INDEX PRED
  315. join condition = [index=libertybans_victim_id_uniqueness
  316. start conditions=[
  317. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_victims"."id"
  318. ] arg_right=[ COLUMN: PUBLIC."libertybans_warns"."victim"
  319. ]]
  320. ]
  321. ] ]
  322. ]
  323. [level=1
  324. isDistinctSelect=[false]
  325. isGrouped=[false]
  326. isAggregated=[false]
  327. columns=[ COLUMN: PUBLIC."libertybans_simple_warns"."id" nullable
  328. COLUMN: PUBLIC."libertybans_simple_warns"."type" nullable
  329. COLUMN: PUBLIC."libertybans_simple_warns"."victim_type" nullable
  330. COLUMN: PUBLIC."libertybans_simple_warns"."victim_uuid" nullable
  331. COLUMN: PUBLIC."libertybans_simple_warns"."victim_address" nullable
  332. COLUMN: PUBLIC."libertybans_simple_warns"."operator" nullable
  333. COLUMN: PUBLIC."libertybans_simple_warns"."reason" nullable
  334. COLUMN: PUBLIC."libertybans_simple_warns"."scope" nullable
  335. COLUMN: PUBLIC."libertybans_simple_warns"."start" nullable
  336. COLUMN: PUBLIC."libertybans_simple_warns"."end" nullable
  337. COLUMN: PUBLIC."libertybans_addresses"."uuid" not nullable
  338. COLUMN: PUBLIC."libertybans_addresses"."address" not nullable
  339.  
  340. ]
  341. [range variable 1
  342. join type=INNER
  343. table=libertybans_simple_warns
  344. alias=puns
  345. cardinality=0
  346. access=FULL SCAN
  347. join condition = [index=SYS_IDX_10223
  348. ]
  349. ] [range variable 2
  350. join type=INNER
  351. table=libertybans_addresses
  352. alias=addrs
  353. cardinality=8959
  354. access=FULL SCAN
  355. join condition = [index=SYS_IDX_10127
  356. other condition=[
  357. OR arg_left=[
  358. OR arg_left=[
  359. AND arg_left=[
  360. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_simple_warns"."victim_type"
  361. ] arg_right=[
  362. VALUE = 0, TYPE = INTEGER]] arg_right=[
  363. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_addresses"."uuid"
  364. ] arg_right=[ COLUMN: PUBLIC."libertybans_simple_warns"."victim_uuid"
  365. ]]] arg_right=[
  366. AND arg_left=[
  367. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_simple_warns"."victim_type"
  368. ] arg_right=[
  369. VALUE = 1, TYPE = INTEGER]] arg_right=[
  370. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_addresses"."address"
  371. ] arg_right=[ COLUMN: PUBLIC."libertybans_simple_warns"."victim_address"
  372. ]]]] arg_right=[
  373. AND arg_left=[
  374. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_simple_warns"."victim_type"
  375. ] arg_right=[
  376. VALUE = 2, TYPE = INTEGER]] arg_right=[
  377. OR arg_left=[
  378. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_addresses"."uuid"
  379. ] arg_right=[ COLUMN: PUBLIC."libertybans_simple_warns"."victim_uuid"
  380. ]] arg_right=[
  381. EQUAL arg_left=[ COLUMN: PUBLIC."libertybans_addresses"."address"
  382. ] arg_right=[ COLUMN: PUBLIC."libertybans_simple_warns"."victim_address"
  383. ]]]]]
  384. ]
  385. ] ]
  386. ]
  387. [level=1
  388. UNION ALL
  389. Left Query=[
  390. UNION ALL
  391. Left Query=[
  392. isDistinctSelect=[false]
  393. isGrouped=[false]
  394. isAggregated=[false]
  395. columns=[ COLUMN: PUBLIC."libertybans_applicable_bans"."id" nullable
  396. COLUMN: PUBLIC."libertybans_applicable_bans"."type" nullable
  397. COLUMN: PUBLIC."libertybans_applicable_bans"."victim_type" nullable
  398. COLUMN: PUBLIC."libertybans_applicable_bans"."victim_uuid" nullable
  399. COLUMN: PUBLIC."libertybans_applicable_bans"."victim_address" nullable
  400. COLUMN: PUBLIC."libertybans_applicable_bans"."operator" nullable
  401. COLUMN: PUBLIC."libertybans_applicable_bans"."reason" nullable
  402. COLUMN: PUBLIC."libertybans_applicable_bans"."scope" nullable
  403. COLUMN: PUBLIC."libertybans_applicable_bans"."start" nullable
  404. COLUMN: PUBLIC."libertybans_applicable_bans"."end" nullable
  405. COLUMN: PUBLIC."libertybans_applicable_bans"."uuid" nullable
  406. COLUMN: PUBLIC."libertybans_applicable_bans"."address" nullable
  407.  
  408. ]
  409. [range variable 1
  410. join type=INNER
  411. table=libertybans_applicable_bans
  412. cardinality=0
  413. access=FULL SCAN
  414. join condition = [index=SYS_IDX_10287
  415. ]
  416. ] ]
  417. ]
  418. Right Query=[
  419. isDistinctSelect=[false]
  420. isGrouped=[false]
  421. isAggregated=[false]
  422. columns=[ COLUMN: PUBLIC."libertybans_applicable_mutes"."id" nullable
  423. COLUMN: PUBLIC."libertybans_applicable_mutes"."type" nullable
  424. COLUMN: PUBLIC."libertybans_applicable_mutes"."victim_type" nullable
  425. COLUMN: PUBLIC."libertybans_applicable_mutes"."victim_uuid" nullable
  426. COLUMN: PUBLIC."libertybans_applicable_mutes"."victim_address" nullable
  427. COLUMN: PUBLIC."libertybans_applicable_mutes"."operator" nullable
  428. COLUMN: PUBLIC."libertybans_applicable_mutes"."reason" nullable
  429. COLUMN: PUBLIC."libertybans_applicable_mutes"."scope" nullable
  430. COLUMN: PUBLIC."libertybans_applicable_mutes"."start" nullable
  431. COLUMN: PUBLIC."libertybans_applicable_mutes"."end" nullable
  432. COLUMN: PUBLIC."libertybans_applicable_mutes"."uuid" nullable
  433. COLUMN: PUBLIC."libertybans_applicable_mutes"."address" nullable
  434.  
  435. ]
  436. [range variable 1
  437. join type=INNER
  438. table=libertybans_applicable_mutes
  439. cardinality=0
  440. access=FULL SCAN
  441. join condition = [index=SYS_IDX_10291
  442. ]
  443. ] ]
  444. ]
  445. ]
  446. Right Query=[
  447. isDistinctSelect=[false]
  448. isGrouped=[false]
  449. isAggregated=[false]
  450. columns=[ COLUMN: PUBLIC."libertybans_applicable_warns"."id" nullable
  451. COLUMN: PUBLIC."libertybans_applicable_warns"."type" nullable
  452. COLUMN: PUBLIC."libertybans_applicable_warns"."victim_type" nullable
  453. COLUMN: PUBLIC."libertybans_applicable_warns"."victim_uuid" nullable
  454. COLUMN: PUBLIC."libertybans_applicable_warns"."victim_address" nullable
  455. COLUMN: PUBLIC."libertybans_applicable_warns"."operator" nullable
  456. COLUMN: PUBLIC."libertybans_applicable_warns"."reason" nullable
  457. COLUMN: PUBLIC."libertybans_applicable_warns"."scope" nullable
  458. COLUMN: PUBLIC."libertybans_applicable_warns"."start" nullable
  459. COLUMN: PUBLIC."libertybans_applicable_warns"."end" nullable
  460. COLUMN: PUBLIC."libertybans_applicable_warns"."uuid" nullable
  461. COLUMN: PUBLIC."libertybans_applicable_warns"."address" nullable
  462.  
  463. ]
  464. [range variable 1
  465. join type=INNER
  466. table=libertybans_applicable_warns
  467. cardinality=0
  468. access=FULL SCAN
  469. join condition = [index=SYS_IDX_10295
  470. ]
  471. ] ]
  472. ]
  473. ]]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!