Sybase, Inc.

Harshada Chavan

Mihnea Andrei

Anil Kumar Goel

Rolando Blanco

Muhammed Sharique

Disclosed herein are system, method, and computer program product embodiments for populating a hash index and returning a handle to the hash index. An embodiment operates by determining, by at least one processor, during query optimization that a first database query has a query execution plan comprising a sub-query which executes N times a correlated predicate having an operator being one of equal and not equal to a base column. A cost of creating and probing the hash index N times and a cost of fully scanning the base column N times are compared based on the correlated predicate. Based on the comparing, it is determined whether to create on-demand a hash index.

Growing community of inventors

Pune, India

Harshada Chavan