Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
We fragment a table by expression on a column of
datetime type. By using
set explain on, I saw that for a transaction witch makes reference only
with the column of fragmentation, the access is sequentel of all the table.
It is a bug Informix ? So yes, It's possible to circumvent it
Thank you very match
↪ replying to mohamed.afeilal@meditel.ma
Madison Pruet — — source: IIUG Forums & Mailing Lists
Please include the where clause of the fragmentation and the where clause
of the query.
"mohamed.afe...."
<mohamed.afeilal@ To: ids@iiug.org
meditel.ma> cc:
Sent by: Subject: Fragmentation on a column type datetime [163]
forum.subscriber@
iiug.org
01/29/2003 02:16
PM
We fragment a table by expression on a column of datetime type. By using
set explain on, I saw that for a transaction witch makes reference only
with the column of fragmentation, the access is sequentel of all the table.
It is a bug Informix ? So yes, It's possible to circumvent it
Thank you very match
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.