Тёмный

How the Function based index works in oracle 

Подписаться
Просмотров 1,5 тыс.
% 38

Topic:- This video explains the concept of "
1. what is the use of Function-Based Indexes
2. how we create Function-Based Indexes in Oracle
3. how it works
4. why it required
5. how to check whether it is used by out a query or not
6. what are the advantages and what are the disadvantages of Function-Based Indexes"
with appropriate examples. how to use and how many types of Indexes are available in Oracle.
it very helpful to all the students and beginners as well. so keep going with oracle shooter.
PlayList:- Oracle Apps Technical
Concept :- #Btree#Composite#Unique#Reversekey #Functionbased#bitmap
Related Videos:-
1. What does Indexes in our queries and why our queries are running slow
:- ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-oN3quk0HixI.html
2. All indexes at one place, B-Tree, Composite, Unique, Reverse Key, Function-Based, Bitmap Index
:- ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Al6z0y3nud4.html
3. B-Tree Index sounds like hard but seriously friends it's very very simple
:- ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-EQ3xszSZ3R0.html
4. Composite and Unique index and difference with B-Tree with Example
:- ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-gLVFBwVkk9c.html
5. How the Function-based index works in oracle
:- ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-XZr-0gwku2A.html
6. Bitmap index, how it works
:- ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-TAfcdioxtGo.html
Full Blogs Link:-
oracleshooter.blogspot.com/2020/04/function-based-function.html
My Vlog Channel link:-
ru-vid.com
Some Full of Entertainment Videos links as below:-
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-VwebFfXUBjM.html
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xgeep1Kqaeg.html
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-JjIiewV1OdE.html
Contact Info:-
Instagram:- mylifemyface
Facebook :- mylifemyface11
Twitter :- mylifemyface11
Blogger :- oracleshooter.blogspot.com
Email Id :- oracle.shooter@gmail.com
Telegram Link:- t.me/joinchat/LKP54BKdxH8-GzaYVWhSmw
whatsapp Group :- chat.whatsapp.com/ISOb4Zs84FR6CqXnWl72MM

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

 

26 апр 2020

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 4   
@pramod7191
@pramod7191 4 года назад
loved one
@EnglishWithNeerav
@EnglishWithNeerav 3 года назад
Brother when you create a function based index Oracle immediately creates another system named column with processed value in the same table that was the reason you saw system name column in the index col view, the new system created column can be verified using user_tab_columns. Thanks
@SanataniHindu5165
@SanataniHindu5165 3 года назад
why we have to use Upper Function in where Clouse after creating the index?
@vishwas22khare
@vishwas22khare 3 года назад
Sir when we create function and when we create a procedure please reply in real time