Queries take too long to return results

1. Load a bucket w/ data - 550k documents.

• Attached sample document
  2. Create a primary index on bucket
  3. Issue a query like – "select count where field1.field2" It takes over 3 minutes for this to return.

Structure of the queried field
doc

{ AirItinerary DirectionInd }

cbq> select count from default where AirItinerary.DirectionInd="Return";
{
"requestID": "6eecf67e-e0e0-492a-8fa7-e4b6221e31d5",
"signature":

{ "$1": "number" }

,
"results": [

{ "$1": 542357 }

],
"status": "success",
"metrics":

{ "elapsedTime": "3m20.160852608s", "executionTime": "3m20.159834295s", "resultCount": 1, "resultSize": 36 }

}