How to select a different index for running your query

+1 vote
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
• 6,260 points
835 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
• 59,230 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
• 59,230 points
1,292 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
• 59,230 points
1,969 views
0 votes
1 answer
0 votes
1 answer

How to install GPU driver for a ubuntu 18.04 instance?

After you create an instance with one ...READ MORE

answered Nov 7, 2019 in GCP by Sirajul
• 59,230 points
1,995 views
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
• 59,230 points
982 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
• 59,230 points
866 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP