Hi Gaurav,
My customer is using version 12.10.FC6WE. They want to know how to avoid automatic index creation when certain queries are executed.
I know that the autoindex feature cannot be controlled, but I just wanted to know if there are any related parameters.
They'd better tune the query (or use directives) or create an index..
------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------
Original Message:
Sent: Tue July 14, 2020 01:48 AM
From: Gaurav Kumar
Subject: Can the autoindex feature be disabled?
Hi SangGyu,
As far as I know, we can not disable that because it was created automatically by optimizer.
If the query plan includes an autoindex path to a large table, you can generally improve performance by adding an index on that column. If you perform a query regularly, you can save time by creating a permanent index.
If you perform the query occasionally, you can reasonably let the database server build and discard an index.
And may I know the version you are running or you are asking this question in general?
------------------------------
Gaurav Kumar
Original Message:
Sent: Mon July 13, 2020 08:31 PM
From: SangGyu Jeong
Subject: Can the autoindex feature be disabled?
Hi,
I would like to know if there is a way to prevent autoindex from being constructed when executing a query.
------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------
#Informix