Hi Vivek, all your videos are very helpful. I also subscribed to your channel Indians Abroad. Awaiting videos on below topics: >> Complex interview questions with large databases (tera,pega bytes) , >> collections with real time scenarios >> Records and Types >> Dynamic SQL >> Oracle provided packages that we often have to use (ex: dbms_lock, dbms_pipe, utl packages.......etc) Thank and Regards, Sujaa
Thanks Sujitha for the kind words :) Please consider subscribing to my other channel as well. It will really help me. th-cam.com/video/6G1xGi-D5ow/w-d-xo.html
Sir, i wrote the same code but my optimizer is not taking index scan. It is doing full table scan operation. Can you please tell me why it is not doing index scan?
There are 3 possible reasons I can think off at this moment. The stats are not gathered The table on which index is created has low amount of data The query is trying to fetch large number of records based on your where condition in that case oracle may prefer full table scan instead of index
I am glad I could help buddy :) Please consider subscribing to my other channel as well. It will really help me th-cam.com/video/6G1xGi-D5ow/w-d-xo.html
Hi Vijaya, it functions like any other index, they all hamper the performance during bulk insert update which is why at times it's advisable to disable the index during the load and rebuild it post the midnight batch load.Basicaally we have to evaluate the advantage it offers in query performance against the overhead it has in maintaining the index and we should act accordingly. I hope it helps.
For sure man, i will work on them. Meanwhile you can check my videos on partitioning, Indexing analytical functions, materialzed views as well. Also I have a small request please subscribe to my other channel and promote it among your friends :) th-cam.com/video/j7RrxEnZ_8E/w-d-xo.html
Very good and useful video on index. Keep going 👍👍👍
Please continue if possible.
..your videos were very comprehensive..we can learn ins and outs of the topics..
Hi Vivek, all your videos are very helpful.
I also subscribed to your channel Indians Abroad.
Awaiting videos on below topics:
>> Complex interview questions with large databases (tera,pega bytes) ,
>> collections with real time scenarios
>> Records and Types
>> Dynamic SQL
>> Oracle provided packages that we often have to use
(ex: dbms_lock, dbms_pipe, utl packages.......etc)
Thank and Regards,
Sujaa
Thanks a lot Suja for the kind words, I will try to create videos on these topics soon.
Thank you for your efforts your videos are simple and easy to understand
I am glad I could help
Hi Vivek, I find all your videos have detailed explanation. Well done. Please make videos on 1) optimizer access paths 2) wait events 3) performance
Hi Vivek, thanks for your knowledge sharing it really helps me . Thanks again for your efforts man !! 👍👏
Thanks a lot buddy , I am glad I could help :)
Great Explanation..
Thanks for index explanation
Great 👌👌👌
Thanks Pankaj for the kind words :)
Nice Detailed description Vivek👌
Thanks a lot Ankush for the kind words, Stay tuned more videos are on the way :)
The new video on Index organized table is live now, Check out here.
Happy learning:)
th-cam.com/video/mIo44Ydnd3o/w-d-xo.html
Nice and clear video ☺️ thank you!!!
Thanks Sujitha for the kind words :)
Please consider subscribing to my other channel as well. It will really help me.
th-cam.com/video/6G1xGi-D5ow/w-d-xo.html
Fantastic bro
Hey Vivek,
Thanks a lot for all your tutorials! My only request to you is please make more videos regularly if possible ! Thank you
Sure Mani, I will be making many more videos soon :)
Nice 👏 explanation!
Thanks Sonia for the kind words :)
Very nice explanation.
Can you create a video on how to read execution plan table
Sure buddy I will work on it soon
Nice Explaination!
Thanks a lot Vicky :)
Could you please make video on Other ways of collecting stats and DBMS stats utilities and TKPROF
Can we create index on trim function
You should be able to do that. The good thing would be to trim your data while storing if possible
Easily understandable explanation... If possible post video on video on complete regular expressions in oralce.
Sure Santhana, I am sorry for delaying .I will be posting it soon
its very interesting tut bro be strong ..if u have tut on trigger thnks
Sir, i wrote the same code but my optimizer is not taking index scan. It is doing full table scan operation. Can you please tell me why it is not doing index scan?
There are 3 possible reasons I can think off at this moment.
The stats are not gathered
The table on which index is created has low amount of data
The query is trying to fetch large number of records based on your where condition in that case oracle may prefer full table scan instead of index
@@TechCoach Yes. All these scenarios are correct. Now i understood. Thank you, Sir!
I am glad I could help buddy :)
Please consider subscribing to my other channel as well.
It will really help me
th-cam.com/video/6G1xGi-D5ow/w-d-xo.html
This is good for small table, but in a large table with bulk insert/update from an etl tool, will this index reduce performance of the insert/update?
Hi Vijaya, it functions like any other index, they all hamper the performance during bulk insert update which is why at times it's advisable to disable the index during the load and rebuild it post the midnight batch load.Basicaally we have to evaluate the advantage it offers in query performance against the overhead it has in maintaining the index and we should act accordingly.
I hope it helps.
@@TechCoach Yes! Thanks. Love the contents of the channel by the way.
Thanks a lot for the kind words, A lot of new content is on the way please keep watching :)
The new video on Index organized table is live now, Check out here.
Happy learning:)
th-cam.com/video/mIo44Ydnd3o/w-d-xo.html
Sir Please 🙏 make Vedios on Collections
For sure man, i will work on them.
Meanwhile you can check my videos on partitioning, Indexing analytical functions, materialzed views as well.
Also I have a small request please subscribe to my other channel and promote it among your friends :)
th-cam.com/video/j7RrxEnZ_8E/w-d-xo.html
I think it’s called function based index not functional index. Right?