oracle11g - Oracle Partitioned Table - How to Count -


i have partitioned table (mytable) on oracle (11g). quite large table, partitioned insert_date column (without time).

the problem that, count(*) gives incorrect result.

the query below returns: 5,726,829,673

select count(*) mytable insert_date >= to_date('01/01/2015', 'dd/mm/yyyy')

the query below returns: 13,076,228,720

select sum(1) mytable insert_date >= to_date('01/01/2015', 'dd/mm/yyyy')

how can possible? reason difference?


Comments

Post a Comment

Popular posts from this blog

ios - Assigning a value out of array of arrays, using section in Xcode -

this code: let servicebonnen = [[1,2,3],[4,5,6],[7,8,9]] //not real data func tableview(tableview: uitableview, cellforrowatindexpath indexpath: nsindexpath) -> uitableviewcell { let cell = tableview.dequeuereusablecellwithidentifier("namecell", forindexpath: indexpath) cell.textlabel!.text = servicebonnen[section][indexpath.row] return cell } but gives me error @ "section" point in line of code: cell.textlabel!.text = servicebonnen[section][indexpath.row] does know why won't compile, , proper solution? you need use section indexpath : indexpath.section your line should this: cell.textlabel!.text = servicebonnen[indexpath.section][indexpath.row]
Read more

javascript - Website analyzer -

i'm having problem, page search products, has getting worse last time. wants display me products can delivered country - still want see of them. have check domins product manually (.com .ca .co.uk etc etc). want build small tool me. i have tried php way: $html=file_get_contents('https://www.ebay.com/sch/i.html?_ipg=200&_from=r40&_sacat=0&_nkw=book&_sop=10'); $dom = new domdocument(); @$dom->loadhtml(mb_convert_encoding($html,"utf8",mb_detect_encoding($html))); $x = new domxpath($dom); foreach($x->query("//li") $node){ $ignore=0; $itemid= $node->getattribute("listingid"); if($itemid >0){ //if (in_array($itemid,$itemsindb)){ echo "itemid=".$itemid."//////text: "; echo $node->nodevalue; echo "<br>"; } but problem is, nodevalue seems missing html tags, since ouput looks this: itemid=322582462268//////text: new listing wind in willows, grahame arthur ra...
Read more