Тёмный

Overview of Oracle Indexes & All About Oracle 19c Automatic Indexes || Real-Time Visualization of AI 

Tekdba
Подписаться 2,3 тыс.
Просмотров 4,2 тыс.
50% 1

In This video, we are going to talk about Oracle Indexes and the Exciting new feature of Oracle 19c which is Automatic Indexes. We are going to experience Automatic Indexes in Live with Step by Step Tutorial from Configuration until Reporting..
We will Talk about Indexes in Oracle and Types of Indexes along with Index Properties. Then we will discuss about Automatic Indexes and How Automatic Indexes Works in 19c. The we will perform Live Demo on Automatic Indexing.
05:16 Automatic Indexes
07:06 Step-By-Step Demonstration of Oracle AI.
13:50 Automatic Index Report Review
Email: tekdba@gmail.com
FB Page: tekdba
Blog: www.tekdba.wordpress.com
LinkedIn: / mani-mohan-raj-selvara...
My Other videos: / tekdba

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

 

19 авг 2019

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 15   
@BalvinderSingh-uh3my
@BalvinderSingh-uh3my 3 года назад
That's was simply an excellent YT video thanks.
@Tekdba
@Tekdba 3 года назад
Thanks @balvinder
@thamiressamiraferreira
@thamiressamiraferreira 3 года назад
Great video! Tekdba
@Tekdba
@Tekdba 3 года назад
Thanks Thamires.. Keep Supporting.
@arsalakhan8184
@arsalakhan8184 Год назад
sir auto indexing can we create in oracle 19c any platform , or it need Exadata hardware
@oldschoolnostalgicgaming3399
Which tool you use? i tied in sqlplus. its show illegal option for alter system
@nagababutalasila5023
@nagababutalasila5023 3 года назад
Can u please explain this feature in non pdb database
@Tekdba
@Tekdba 3 года назад
Hi Nagababu, Oracle Indexes works seamlessly with PDB & Non-PDB. There are no differences
@mi3thakrar
@mi3thakrar 3 года назад
Does automatic index take DML queries into consideration when suggesting any index?
@Tekdba
@Tekdba 3 года назад
Yes.. basically it uses the optimizer statistics to create automatic indexes
@mi3thakrar
@mi3thakrar 3 года назад
@@Tekdba Can you please explain how optimizer statistics help to suggest any index ?
@harikrishna-sh7mc
@harikrishna-sh7mc 4 года назад
Can u send me the steps u followed ,so that I can test it from my side .. thanks
@Tekdba
@Tekdba 4 года назад
Hi Hari, Please refer my blog tekdba.wordpress.com for details instruction.
@mercylane6755
@mercylane6755 4 года назад
The demo part is too fast to follow through. Otherwise, it’s very informative.
@Tekdba
@Tekdba 4 года назад
Thanks for your comment Mercy. Will follow your suggestion..
Далее
Oracle Database Histograms : What are they
22:12
Просмотров 1,1 тыс.
Auto Indexing in Oracle 19C
5:04
Просмотров 1,6 тыс.