SQL Search in Cache

Note

This feature is only available in NCache Enterprise Edition.

NCache provides a faster and efficient searching mechanism which lets you search your cache according to a given criteria and gets the result set. Various ways to search the cache according to SQL queries are explained in the successive chapters.

In This Section

SQL Search Behavior and Usage Overview
Discusses the basic overview of searching cache with SQL along with the topology wise behavior.

SQL Search for Keys Syntax and Usage
Discusses how to search the cache for keys according to the query criteria.

SQL Search for Objects Syntax and Usage Syntax and Usage
Discusses how to search the cache for objects according to the query criteria.

SQL IN Operator Syntax and Usage
Discusses how to use the IN operator in SQL like format.

SQL Like Operator Syntax and Usage
Discusses how to use the LIKE operator in SQL like format.

SQL GROUP BY Syntax and Usage
Discusses how to use the GROUP BY clause in SQL like format.

SQL ORDER BY Syntax and Usage
Discusses how to use the ORDER BY clause in SQL like format.

SQL Delete Statement Syntax and Usage
Discusses how to delete the items from the cache using SQL like format.

SQL Datetime Function Syntax and Usage
Discusses how to use the Date funtions for querying the data.

SQL Logical Operators Usage
Discusses how to use the logical operators for querying the data.

SQL Reference for NCache
Explains the SQL syntax and all the query formats supported by NCache.