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

Hi Chris, Amazing videos with simple and clear way of explanation.👍
I Do have a doubt, if we have a table where 90-95% of a column data values are unique. can we still create a primary key or unique index on that column. how can we use that column values efficiently for data access?

You really made my day :-)

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.

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?

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,

Brilliant! This deserves more views

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

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

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

Amazing!! Thanks!

This was awesome man thank you very much

BRILLIANT thank you <3

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

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

Woooooow, 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!