hello world!
query
RESULTSET
query
  ANIMAL_ID EBV
1 427128 139.72867
2 392364 139.53
3 427127 120.19583
4 427126 120.19583
5 395371 119.354996
6 423445 118.985
7 427134 118.705666
8 427135 118.705666
9 427082 117.725
10 421747 109.68
11 41372 107.04
12 412692 106.235
13 442396 105.76276
14 444583 105.25389
15 443300 104.8975
16 396162 103.163994
17 446744 103.1275
18 406774 102.31733
19 444725 100.915
20 419121 100.789825
21 426263 100.615
22 417381 100.38534
23 443308 100.307495
24 444171 100.270004
25 444563 100.08501
26 443305 99.1225
27 444585 97.633224
28 446759 97.277664
29 420856 96.9375
30 444545 96.93554
31 443677 95.54133
32 443309 95.229996
33 444278 95.14
34 446712 94.992584
35 417278 94.64
36 408649 92.99
37 446309 92.30958
38 425305 92.27875
39 402785 92.229996
40 426865 91.796295
41 426862 91.773125
42 443297 91.5625
43 409024 91.330666
44 417373 91.31625
45 446747 91.24483
46 446748 91.24483
47 431138 90.96391
48 444544 89.537704
49 426634 89.32567
50 444280 88.95
51 425247 88.88
52 431122 88.53
53 409290 87.369995
54 444178 86.919754
55 444177 86.919754
56 427033 86.869995
57 427034 86.869995
58 445050 85.91
59 446711 85.845
60 443299 85.845
61 428677 85.64
62 417279 85.537506
63 413871 85.4
64 421751 85.3095
65 409292 84.79
66 443298 84.0175
67 412046 83.60333
68 443302 82.96834
69 444169 79.72
70 411637 79.705505
71 409699 78.83
72 402722 77.035
73 446722 76.315
74 412049 75.33833
75 445848 75.127
76 407933 75.063995
77 444183 73.07
78 426840 72.79633
79 417277 71.79
80 420844 59.962666
81 387209 59.79
82 391293 56.74
83 446725 56.215
CACHED false
EXECUTIONTIME 326
SQL select a.animal_id, c.ebv from animal a, cbv c where c.animal_id = a.animal_id and c.ebv_type in ( 0, 1 ) and c.trait_cd = 'CIndx' and a.breed_cd = 'AI' and a.sex_cd = 'M' and ( a.logo = 'C' or a.animal_id in ( select animal_id from aka where animal_id = a.animal_id and logo = 'C' ) ) and ( exists ( select 1 from animal p, aka x where p.animal_id = x.animal_id and p.sire_id = a.animal_id and p.birth_date > date('today') - date('2 years') and ( p.logo = 'C' or x.logo = 'C' ) ) or a.birth_date > date('today') - date('2 years' ) ) order by ebv desc