My Oracle Support Banner

Change in Execution Plan when huge number of rows loaded into the table (Doc ID 1284117.1)

Last updated on AUGUST 17, 2023

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.1.6.6 and later
Information in this document applies to any platform. *** ***

Symptoms

After ttbulkcp is executed on the table the execution plan generated for the below query was changed and query become very slow.

Steps Followed
---------------

1) Inserted records into the table using ttbulkcp


Here the optimizer is using the TblLkTtreeScan along with <table02>.XXX_DATE_S >= <table01>.XXX_DATE_S condition in the execution plan. The exucution time was very high. It was taking 241 seconds.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.