# GCP BigQuery Optimization | Cloud Efficiency Hub

Canonical: https://www.pointfive.co/efficiency-hub/cloud-services/gcp-bigquery

Comprehensive guide to GCP BigQuery cost optimization. Identify and fix common inefficiencies to reduce cloud spend.

# GCP BigQuery

Comprehensive guide to GCP BigQuery cost optimization. Identify and fix common inefficiencies to reduce cloud spend.

[Contribute](https://form.typeform.com/to/RtEajZdo?typeform-source=hub.pointfive.co)

Category

Cloud provider

## All inefficiencies

4 inefficiencies

/

| Cloud | Reference | Inefficiency | Service | Category |
| --- | --- | --- | --- | --- |
|  | CER-0295 | [Overselecting Data and Misusing LIMIT for Cost Control in BigQuery](https://www.pointfive.co/efficiency-hub/inefficiencies/overselecting-data-and-misusing-limit-for-cost-control-in-bigquery)  GCP BigQuery / Other | GCP BigQuery | Other |
|  | CER-0226 | [Unoptimized Billing Model for BigQuery Dataset Storage](https://www.pointfive.co/efficiency-hub/inefficiencies/unoptimized-billing-model-for-bigquery-dataset-storage)  GCP BigQuery / Databases | GCP BigQuery | Databases |
|  | CER-0069 | [Inefficient Use of Reservations in BigQuery](https://www.pointfive.co/efficiency-hub/inefficiencies/inefficient-use-of-reservations-in-bigquery)  GCP BigQuery / Databases | GCP BigQuery | Databases |
|  | CER-0024 | [Unnecessary Reset of Long-Term Storage Pricing in BigQuery](https://www.pointfive.co/efficiency-hub/inefficiencies/unnecessary-reset-of-long-term-storage-pricing-in-bigquery)  GCP BigQuery / Databases | GCP BigQuery | Databases |

---
Source: the public page above. Product screenshots and illustrative interfaces are examples, not live customer data.