Functional Indexes in Oracle

แชร์
ฝัง
  • เผยแพร่เมื่อ 6 ธ.ค. 2024

ความคิดเห็น • 45

  • @harshiniborra4933
    @harshiniborra4933 ปีที่แล้ว

    Please continue if possible.
    ..your videos were very comprehensive..we can learn ins and outs of the topics..

  • @sujaa1000
    @sujaa1000 4 ปีที่แล้ว +3

    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

    • @TechCoach
      @TechCoach  4 ปีที่แล้ว

      Thanks a lot Suja for the kind words, I will try to create videos on these topics soon.

  • @saidtel1978
    @saidtel1978 7 หลายเดือนก่อน +1

    Thank you for your efforts your videos are simple and easy to understand

    • @TechCoach
      @TechCoach  7 หลายเดือนก่อน

      I am glad I could help

  • @mithunmohan5727
    @mithunmohan5727 6 หลายเดือนก่อน

    Very good and useful video on index. Keep going 👍👍👍

  • @koushikbadhri743
    @koushikbadhri743 2 ปีที่แล้ว

    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

  • @aadhithanradhakrishnan6166
    @aadhithanradhakrishnan6166 2 ปีที่แล้ว +1

    Hi Vivek, thanks for your knowledge sharing it really helps me . Thanks again for your efforts man !! 👍👏

    • @TechCoach
      @TechCoach  2 ปีที่แล้ว +1

      Thanks a lot buddy , I am glad I could help :)

  • @huzaifaansari8688
    @huzaifaansari8688 2 ปีที่แล้ว +1

    Very nice explanation.
    Can you create a video on how to read execution plan table

    • @TechCoach
      @TechCoach  2 ปีที่แล้ว

      Sure buddy I will work on it soon

  • @ravishsinha2708
    @ravishsinha2708 3 ปีที่แล้ว

    Great Explanation..

  • @hussamna
    @hussamna ปีที่แล้ว

    Thanks for index explanation

  • @thepowerofpositivethinking2593
    @thepowerofpositivethinking2593 2 ปีที่แล้ว

    its very interesting tut bro be strong ..if u have tut on trigger thnks

  • @shikhasahany7597
    @shikhasahany7597 ปีที่แล้ว +1

    Could you please make video on Other ways of collecting stats and DBMS stats utilities and TKPROF

  • @maniji5756
    @maniji5756 4 ปีที่แล้ว

    Hey Vivek,
    Thanks a lot for all your tutorials! My only request to you is please make more videos regularly if possible ! Thank you

    • @TechCoach
      @TechCoach  4 ปีที่แล้ว +1

      Sure Mani, I will be making many more videos soon :)

  • @santhanarajagopal6116
    @santhanarajagopal6116 4 ปีที่แล้ว

    Easily understandable explanation... If possible post video on video on complete regular expressions in oralce.

    • @TechCoach
      @TechCoach  4 ปีที่แล้ว

      Sure Santhana, I am sorry for delaying .I will be posting it soon

  • @ankushgondane8642
    @ankushgondane8642 5 ปีที่แล้ว

    Nice Detailed description Vivek👌

    • @TechCoach
      @TechCoach  5 ปีที่แล้ว

      Thanks a lot Ankush for the kind words, Stay tuned more videos are on the way :)

    • @TechCoach
      @TechCoach  5 ปีที่แล้ว

      The new video on Index organized table is live now, Check out here.
      Happy learning:)
      th-cam.com/video/mIo44Ydnd3o/w-d-xo.html

  • @rameshbabu7832
    @rameshbabu7832 ปีที่แล้ว

    Fantastic bro

  • @sujis9263
    @sujis9263 3 ปีที่แล้ว

    Nice and clear video ☺️ thank you!!!

    • @TechCoach
      @TechCoach  3 ปีที่แล้ว +1

      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

  • @shrikantpatil2094
    @shrikantpatil2094 3 ปีที่แล้ว +1

    Can we create index on trim function

    • @TechCoach
      @TechCoach  3 ปีที่แล้ว

      You should be able to do that. The good thing would be to trim your data while storing if possible

  • @pankajkharade6936
    @pankajkharade6936 3 ปีที่แล้ว

    Great 👌👌👌

    • @TechCoach
      @TechCoach  3 ปีที่แล้ว

      Thanks Pankaj for the kind words :)

  • @soniabharti3304
    @soniabharti3304 4 ปีที่แล้ว

    Nice 👏 explanation!

    • @TechCoach
      @TechCoach  4 ปีที่แล้ว

      Thanks Sonia for the kind words :)

  • @siddharthapenchala8146
    @siddharthapenchala8146 2 ปีที่แล้ว +1

    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?

    • @TechCoach
      @TechCoach  2 ปีที่แล้ว +1

      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

    • @siddharthapenchala8146
      @siddharthapenchala8146 2 ปีที่แล้ว +1

      @@TechCoach Yes. All these scenarios are correct. Now i understood. Thank you, Sir!

    • @TechCoach
      @TechCoach  2 ปีที่แล้ว +1

      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

  • @vickypatekar9532
    @vickypatekar9532 5 ปีที่แล้ว

    Nice Explaination!

    • @TechCoach
      @TechCoach  4 ปีที่แล้ว

      Thanks a lot Vicky :)

  • @vickypatekar9532
    @vickypatekar9532 5 ปีที่แล้ว

    Sir Please 🙏 make Vedios on Collections

    • @TechCoach
      @TechCoach  5 ปีที่แล้ว

      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

  • @VijayaRohithK
    @VijayaRohithK 5 ปีที่แล้ว

    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?

    • @TechCoach
      @TechCoach  5 ปีที่แล้ว +1

      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.

    • @VijayaRohithK
      @VijayaRohithK 5 ปีที่แล้ว

      @@TechCoach Yes! Thanks. Love the contents of the channel by the way.

    • @TechCoach
      @TechCoach  5 ปีที่แล้ว +1

      Thanks a lot for the kind words, A lot of new content is on the way please keep watching :)

    • @TechCoach
      @TechCoach  5 ปีที่แล้ว

      The new video on Index organized table is live now, Check out here.
      Happy learning:)
      th-cam.com/video/mIo44Ydnd3o/w-d-xo.html

  • @robk4099
    @robk4099 2 ปีที่แล้ว

    I think it’s called function based index not functional index. Right?