Querying

Tanzu GemFire provides a SQL-like querying language called OQL that allows you to access data stored in Tanzu GemFire regions.

Since Tanzu GemFire regions are key-value stores where values can range from simple byte arrays to complex nested objects, Tanzu GemFire uses a query syntax based on OQL (Object Query Language) to query region data. OQL is very similar to SQL, but OQL allows you to query complex objects, object attributes, and methods.

• Querying FAQ and Examples

  This topic answers some frequently asked questions on querying functionality. It provides examples to help you get started with Tanzu GemFire querying.

• Querying with OQL

  This section provides a high-level introduction to Tanzu GemFire querying such as building a query string and describes query language features.

• Writing and Executing a Query in OQL

  This section explains how to create a Query object and use it to perform query-related operations.

• Advanced Querying

  This section includes advanced querying topics such as using query indexes, using query bind parameters, querying partitioned regions and query debugging.

• Working with Indexes

  The Tanzu GemFire query engine supports indexing. An index can provide significant performance gains for query execution.