How to create Indexes In SQL | How to choose columns when creating indexes

Indexes in sql, indexing in dbms, Indexes in sql, indexes in oracle, indexes in dbms, sql indexes explained, oracle indexes explained

[anushdp]

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.

[ZainAli-jscs]

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.

[someshmahajan]

I've seen too much videos but your is very short and easy to understand....
keep it up....

[deepak-lvvn]

Your playlist is very helpful !.... Thanks for this.

[tazhossain]

I am a fan of your teaching..please make more videos.

[nickrathore]

So finally u started SEO great keep it up

[punyabikash]

Very good explanations n Very helpful thanks a lot keep going 👍👍

[Kulsumkookie]

Hey Sadia 👋 . One suggestion I need, can you help?

[mukulverma]

great explaining and your voice amazing mam..

[ameetpalsingh]

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.

[faizkhan]

thankx for ur videos, its very helpful, short and simple

[dipakit]

Please create video on Complex Query also and real time also.

[ZionREI_CN]

Hi thanks for your video, please make your video into a digital presentation format. It will be more pop

[girijeshgothriwal]

I know SQL intermediate level. Can you please refer one book which covers almost everything related to mysql?

[amanpinjarit]

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

[girijeshgothriwal]

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.

[karandhawan]

Thank you so This is exactly what i was searching for 😊

[sivasu]

Amulya's academy youTube channel is yours?
I'm right

[salmanhussain]

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!

[dreambig]

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