The EXPLAIN command should help. http://phoenix.apache.org/language/index.html#explain On Thu, Oct 23, 2014 at 5:40 AM xuxc1120 <[email protected]> wrote:
> environment： > hadoop-2.3.0-cdh-5.1.0 > hbase-0.98.1-cdh-5.1.0 > phoenix-4.1.0 > > i have create a table in phoenix client ,and then create index on some > columns, after that ,i insert data to table, > the data have inserted successful and the index table also have records, > > but when i use "select * from tb1 where condition=1 and condition2=2" > clause in the phoenix client , for 180W data, it takes almost 10sec, i want > to know if the index works? > >
