: James Heather
To: user@phoenix.apache.org
Sent: Wednesday, September 30, 2015 8:08 PM
Subject: Re: Explain plan over primary key column
I don't see why it wouldn't be able to use the index for that.
In any case, if that's what "explain" is telling you, I think you
olumns in the query are a
part of it.
Sorry again.
Sumit
*From:* James Heather
*To:* user@phoenix.apache.org
*Sent:* Wednesday, September 30, 2015 7:58 PM
*Subject:* Re: Explain plan over primary key column
Yup
On 30
index is still used. I thought that
global indexes are only used when all columns in the query are a part of it.
Sorry again.Sumit
From: James Heather
To: user@phoenix.apache.org
Sent: Wednesday, September 30, 2015 7:58 PM
Subject: Re: Explain plan over primary key column
Yup
s used?
*From:* James Heather
*To:* user@phoenix.apache.org
*Sent:* Wednesday, September 30, 2015 7:49 PM
*Subject:* Re: Explain plan over primary key column
You're asking for every single row of the table, so nothing's going to
avoid a full scan. The index would
2015 7:49 PM
Subject: Re: Explain plan over primary key column
You're asking for every single row of the table, so nothing's going to avoid a
full scan. The index wouldn't help.
On 30/09/15 15:18, Sumit Nigam wrote:
Hi,
I have a table as:
CREATE TABLE EXP (ID BI
You're asking for every single row of the table, so nothing's going to
avoid a full scan. The index wouldn't help.
On 30/09/15 15:18, Sumit Nigam wrote:
Hi,
I have a table as:
CREATE TABLE EXP (ID BIGINT NOT NULL PRIMARY KEY, TEXT VARCHAR);
If I explain the select:
EXPLAIN SELECT ID FROM EX
