reverse key index -- Sorting expected?
From: Vishnu Potukanuma <vishnupotukanuma_at_gmail.com>
Date: Mon, 6 Jan 2020 12:08:50 +0530
Message-ID: <CAP-RywzTiuP5qwnREDZAnzuhNW0oerF-aA0Q9=T3JwBLxPCp5g_at_mail.gmail.com>
Hi,
Date: Mon, 6 Jan 2020 12:08:50 +0530
Message-ID: <CAP-RywzTiuP5qwnREDZAnzuhNW0oerF-aA0Q9=T3JwBLxPCp5g_at_mail.gmail.com>
Hi,
WAIT #140452225803960: nam='db file sequential read' ela= 228 file#=7 block#=18162 blocks=1 obj#=74643 tim=5897434785 WAIT #140452225803960: nam='db file sequential read' ela= 221 file#=7 block#=18080 blocks=1 obj#=74643 tim=5897435085 WAIT #140452225803960: nam='SQL*Net message to client' ela= 1 driverid=1650815232 #bytes=1 p3=0 obj#=74643 tim=5897435152
WAIT #140452225803960: nam='db file sequential read' ela= 214 file#=7 block#=19545 blocks=1 obj#=74643 tim=5897435399 WAIT #140452225803960: nam='db file sequential read' ela= 213 file#=7 block#=19383 blocks=1 obj#=74643 tim=5897435681 WAIT #140452225803960: nam='db file sequential read' ela= 209 file#=7 block#=20929 blocks=1 obj#=74643 tim=5897435960 WAIT #140452225803960: nam='db file sequential read' ela= 192 file#=7 block#=20686 blocks=1 obj#=74643 tim=5897436213 WAIT #140452225803960: nam='db file sequential read' ela= 183 file#=7 block#=22313 blocks=1 obj#=74643 tim=5897436471 WAIT #140452225803960: nam='db file sequential read' ela= 202 file#=7 block#=21989 blocks=1 obj#=74643 tim=5897436735 WAIT #140452225803960: nam='db file sequential read' ela= 223 file#=7 block#=23696 blocks=1 obj#=74643 tim=5897437039 WAIT #140452225803960: nam='db file sequential read' ela= 207 file#=7 block#=23292 blocks=1 obj#=74643 tim=5897437320
Is this a bug? from what I look at applying a hash function to eliminate the duplicates and sorting the results especially for reverse key indexes is basically an unnecessary step....
Thanks,
Vishnu
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 06 2020 - 07:38:50 CET