Home > database >  The volume of how statistics three tables
The volume of how statistics three tables

Time:09-21

Select count (*) from hbase1 where flag=0;
Select count (*) from hbase2 where flag=0;
Select count (*) from hbase3 where flag=0;

I need to do a monitoring program, monitoring the three tables in accordance with the conditions of the amount of data every day, the three tables every day hundreds of millions of new data come in. But the use of the SQL statement efficiency is too low, is there any way quickly concluded that the data

CodePudding user response:

How many letters are there in the flag not heavy value? If not, consider "bitmap index", first you search, there is a problem to ask again,
  • Related