Creating Indexes on partitioned tables

Подписаться 15 тыс.

Просмотров 7 тыс.

50% 1

An index normally points to a row in a physical segment (a table). But a partitioned table consists of multiple physical segments, so the index structures and the data contained within the index need to be slightly different for partitioned tables.
Follow me!
blog: connor-mcdonald.com
twitter: / connor_mc_d
Full playlist: • An introduction to Par...
The Podcast!
podcasts.apple.com/au/podcast...
open.spotify.com/show/5dqVVft...
Subscribe for new tech videos every week
Other social media channels here: linktr.ee/connor
A free Oracle database forever ?! Oh yes indeed!
www.oracle.com/cloud/free
Music: Night Owl (Broke For Free), Kevin Mcleod (incomptech), Dyalla, Bensounds
#oracle #partitioning

Наука

Опубликовано:

24 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 9

@SudhirBhajnawale Год назад

Very well explained. Thanks

@giorgio89458 Год назад

Hello! what happens if I add the clause "UPDATE INDEXES" even if I drop a partition with a local partitioned index? will it give me some errors?

@DatabaseDude Год назад

it will work fine

@Firatayrilik 6 месяцев назад

Do indexes make queries on partitioned tables even faster? For example, for the index on "customer" column in this video, for which type of queries does the index become more efficient?

@DatabaseDude 6 месяцев назад

Maybe faster...maybe slower. The same rules apply - namely, do we reduce the amount of IO, and does the benefit outweigh the cost of keeping that index up to date.

@alessioruggi9676 3 месяца назад

I want to ask something that could seems trivial, but i can't find online nothing that txplains it well. Why status for partitioned index is "N/A"? i've been able only yo find this definition "N/A indicates that index is a partitioned index, not applicable for User_indexes and dba_indexes need to view with user_ind_partitions and dba_ind_partitions." I can't really get what the part after the comma means, and also what the N/A stands for?

@DatabaseDude 3 месяца назад

N/A means the status is determined at a lower level. For example, if you have 8 partitions in an index, and 3 are "unusable" and 5 are "usable", then you really can't make a statement about the overall status of the index, hence "N/A"

@alessioruggi9676 3 месяца назад

@@DatabaseDude thanks a lot!