How to select a different index for running your query?

0 votes
I want to run a query with a different index, instead of the default. How do I choose a different index?
Nov 20, 2019 in GCP by anonymous
• 5,330 points
39 views

1 answer to this question.

0 votes

After you find the index that Cloud Spanner used for your query, try running your query with a different index, or by scanning the base table instead of using an index. 

To specify the index, add a FORCE_INDEX directive to the query.

If you find a faster version of the query, update your application to use the faster version.

For more info refer https://cloud.google.com/spanner/docs/troubleshooting-performance-regressions#choose-index

answered Nov 20, 2019 by Sirajul
• 50,440 points

Related Questions In GCP

0 votes
1 answer

How can i grant access to a GCP project for a large scale multiple users at once?

gcloud auth to service accounts is allowed. ...READ MORE

answered Oct 16, 2019 in GCP by Sirajul
• 50,440 points
123 views
0 votes
1 answer

How to disable the Kubernetes Dashboard for a GKE cluster?

The Kubernetes Dashboard is disabled by default on ...READ MORE

answered Oct 30, 2019 in GCP by Sirajul
• 50,440 points
139 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Create a Cloud spanner instance.

You can create an instance with the gcloud command-line ...READ MORE

answered Nov 13, 2019 in GCP by Sirajul
• 50,440 points
92 views
0 votes
1 answer

Deleting a Cloud Spanner instance

Deleting an instance permanently removes the instance ...READ MORE

answered Nov 13, 2019 in GCP by Sirajul
• 50,440 points
42 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer