Skip to Main Content
  • Questions

  • Is there a way to create local hash partition index?

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Hui.

Asked: January 19, 2017 - 10:11 am UTC

Last updated: January 19, 2017 - 10:45 am UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

Is there a way to create local hash partition index?
I can create global hash partition index, but local does not work.

with LiveSQL Test Case:
https://livesql.oracle.com/apex/livesql/s/egetwo07xximwfsock40odij5

and Chris said...

A local partitioned index uses the same partitioning strategy as the table. So if you want a hash partitioned index, either you need to:

1. Hash partition the table
2. Create a global hash partitioned index

http://docs.oracle.com/database/122/CNCPT/partitions-views-and-other-schema-objects.htm#GUID-4A4464E1-500F-4BB6-85E4-7D2E637A47FF

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

VLDB

If you are new to partitioning, check out Connor McDonald's introduction series here.

VLDB

Documentation set on VLDB and Partitioning.