How to Create Database Indexes: Databases for Developers: Performance #4

Indexes are one of the most common performance tools available.

But how do you create one? And how does it help the database find your data faster?

Watch this video to learn how to create an index and know if the optimizer used it.

Need help with SQL?



============================
The Magic of SQL with Chris Saxon

Copyright © 2020 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.

[sebon]

man! This was SO CLEAR explanation, nice! I'm impressed with the quality of the vid with everything - sound hq, switching between bricks, code and drawings where needed, highlighting the stuff and everything. Very good video!

[Sam-Land]

I wish I had watched this years ago to explain the ordering. I'm going to be breaching this video

[SubhashPophale]

This won't be exaggeration if I say you read a whole lot pages and watch the this 13 min video. Excellent and lucid explaination of Indexes in oracle database.

[eduardodelcorrallira]

I was about to thumb it up and realized it already was. Plenty of Aha! Moments
Very clear, and fun too :)

[amirthalakshmi]

Thank you very much... It's really really very very useful., .. This series deserves more views..

[NickNA]

Wonderful explanation. Only a observation, complexity for the use of index in B-tree is O(log(N)) where the logarithm base is b.

[kevingergely]

This was awesome man thank you very much

[akadiryigit]

Hi Chris, Thanks for sharing the video, It is easy to understand and I love it. :) Could you please answer my questions when you have time ?

I have a question about differences between Partition and Index. When should we use Index or Partition ? Why should choose Partition instead of Index.

Thanks,

[HarrietOmboga]

I like how its explained though I dont get most of it

[NuProg]

I have to create index for a huge table (In Gigabytes) for a new column. But when we tried this, it is bringing down the system completely so we had to drop that. Is there any way we can create this index without downtime.

[premjithtube]

How many index can create against a table?? Instead of creating index(color, shape), wat abt creating two separate indexs with these columns and use in the query?

[sebon]

P.s. you're from UK or USA? Or even Australia maybe?