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 in GCP by anonymous
• 4,330 points
16 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 by Sirajul
• 40,980 points

Related Questions In GCP

0 votes
1 answer
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 in GCP by Sirajul
• 40,980 points
28 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 in GCP by Sirajul
• 40,980 points
27 views
0 votes
1 answer

Deleting a Cloud Spanner instance

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

answered Nov 13 in GCP by Sirajul
• 40,980 points
21 views
0 votes
1 answer