How to find out what index Cloud Spanner is using to process a query?

0 votes
I have a cloud spanner instance along with its own database that is somewhere around 1.7TB. How do I  find out what index Cloud Spanner is using to process a query?
Nov 20 in GCP by anonymous
• 4,330 points
13 views

1 answer to this question.

0 votes

To find out what index Cloud Spanner is using to process a query, view the query execution plan in the Google Cloud Platform Console:

  1. Go to the Cloud Spanner Instances page in the GCP Console.

  2. Click the name of the instance you want to query.

  3. In the left pane, click the database you want to query, then click search Query.

  4. Enter the query to test.

  5. In the Run query drop-down list, select Explanation only. Cloud Spanner displays the query plan.

answered Nov 20 by Sirajul
• 40,980 points
How to select a different index for running your query?

Related Questions In GCP

0 votes
1 answer
0 votes
1 answer

How to create a Cloud dataproc cluster withn custom machne type using gcloud?

Run the gcloud dataproc clusters create command with the ...READ MORE

answered Nov 26 in GCP by Sirajul
• 40,980 points
18 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 in GCP by Sirajul
• 40,980 points
29 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
22 views
0 votes
1 answer