Hi, thanks to your videos, I landed an internship at a very good company! Thank you very much, I have told all my friends to subscribe to your channel.
Watched all 3 videos and these were very helpful. The way you have explained everything so simply that it seems so easy to understand. Please keep making these videos you are very good at it. Keep up the good work.
I want to clarify the use of index for table, usually inserts are not big issues as compared to delete due to the behavior of B-Trees. Also, in update if we are changing the index columns, database will treat it as a delete and insert query so it will take much more time as compared to delete or insert query. If we are not changing any index column, then operation will not take much time. So for non-key columns always think twice before adding it as a index.
In this case we can drop index first then we will execute update and insertion now then it will not take much time so finally after updation or whatever we can again add indexes this might help right
@@bharathms5560 hey Bharat, i am a database administrator working on production servers for the last 7 months. I am good at my work. Can you suggest any certification for advancing my career ? Please
Hi, Kindly provide the answer below things 1. How columnstore indexes are different from normal index 2. How columnstore index & rowstore indexes data gets stored in table 3. Why do we have only one clustered index in a table why can't I create more than one clustered index in the table. 4. When we needs to create indexes on the table 5. Is indexes supportive while performing dml if not why ? 6. Can we use not clustured indexes instead of clustured for a tables and how it will be more useful 7. Which one is better clustured or no clustered . When to use clustered n when to use non clustered ? I have more Q with my experience so u answer this will get back to you . Thanks Vivek Dubey
Uncle ko lag raha hai boss hai. 😂 Jo Bolenge Uska Jawab de inko. aree uncle Thoda manners toh seekho. Request KARNA Aur ORDER Dene ME Farak HAI. Thoda akkal use karo
Hi, thanks to your videos, I landed an internship at a very good company! Thank you very much, I have told all my friends to subscribe to your channel.
This makes me so happy. Congratulations!!
@@crackconcepts Thanks😊
Watched all 3 videos and these were very helpful. The way you have explained everything so simply that it seems so easy to understand. Please keep making these videos you are very good at it. Keep up the good work.
Your playlist is very helpful !.... Thanks for this.
I've seen too much videos but your is very short and easy to understand....
keep it up....
Congrats on 100K
Please upload more videos on SQL
Yes
Hyy
I am a fan of your teaching..please make more videos.
U have nyc communication skills
great explaining and your voice so................... amazing mam..
Nice note
thankx for ur videos, its very helpful, short and simple
So finally u started SEO great keep it up
Very good explanations n Very helpful thanks a lot keep going 👍👍
doubt clarified and tq
Please create video on Complex Query also and real time also.
Hi thanks for your video, please make your video into a digital presentation format. It will be more pop
Thank you so much!!!!! This is exactly what i was searching for 😊
thanks, you explained it very well..
Thanks for your videos !!
I want to clarify the use of index for table, usually inserts are not big issues as compared to delete due to the behavior of B-Trees. Also, in update if we are changing the index columns, database will treat it as a delete and insert query so it will take much more time as compared to delete or insert query. If we are not changing any index column, then operation will not take much time. So for non-key columns always think twice before adding it as a index.
In this case we can drop index first then we will execute update and insertion now then it will not take much time so finally after updation or whatever we can again add indexes this might help right
Hey Sadia 👋 . One suggestion I need , can you help?
Make video on Plsql and advanced SQL
Lots of information provided in small time thanku madam but the page is not clearly visible also your speaking too fast some and too slow some time
Again ..nice one... keep going
tq mam nice video
Congrats for 5000 subscribers
Thank you 😊
Crack Concepts you deserve more than that for your hard working attitude 🤗🤗🤗🤗
@@crackconcepts 🥰🥰🥰🥰🥰
I know SQL intermediate level. Can you please refer one book which covers almost everything related to mysql?
If you get to know of any book or website for advanced SQL concepts, please let me know. Thanks in advance
@@bharathms5560 hey Bharat, i am a database administrator working on production servers for the last 7 months. I am good at my work. Can you suggest any certification for advancing my career ? Please
Hi, please share your email Id or create one dummy email Id so that we can give some scenarios and you can make a video on that.
awesome
Thank you❤❤❤❤❤
Amulya's academy youTube channel is yours?
I'm right
👍
Hai,madam
❤️
Hey Sadia, big fan of your teaching style. I sent you an email and I'd really appreciate it if you could take a look at it.
Thanks a ton!
Hi,
Kindly provide the answer below things
1. How columnstore indexes are different from normal index
2. How columnstore index & rowstore indexes data gets stored in table
3. Why do we have only one clustered index in a table why can't I create more than one clustered index in the table.
4. When we needs to create indexes on the table
5. Is indexes supportive while performing dml if not why ?
6. Can we use not clustured indexes instead of clustured for a tables and how it will be more useful
7. Which one is better clustured or no clustered . When to use clustered n when to use non clustered ?
I have more Q with my experience so u answer this will get back to you .
Thanks
Vivek Dubey
Uncle ko lag raha hai boss hai. 😂
Jo Bolenge Uska Jawab de inko. aree uncle Thoda manners toh seekho. Request KARNA Aur ORDER Dene ME Farak HAI. Thoda akkal use karo
Chacha itna type/copy karne se acha Google kar lete 😂
@@prajaktashah6359 🤦🤣😆direct third degree, this is not fair Haa 🤣
Plsql