Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

INMEMORY TABLE still using Index

Uday K ReddyMar 27 2019 — edited Mar 28 2019

I have Oracle 12.1.0.2 database, with INMEMORY SIZE 100G and SGA250G.

I have populated few tables into inmemory and few tables are still using INDEXES in EXPLAIN PLAN. Any Idea?

If I run a simpe query explain plan shows INMEMORY but if add complex GROUP by and filters it starts using INDEX.

Added on Mar 27 2019

#general-database-discussions

16 comments

1,320 views