Lec-93: Secondary Index in Database with Example | Multilevel Indexing

hello friends welcome to gates measure the topic is secondary index secondary index UGC net or gate key point of view so important hey sub C beta problem hey up a digital AV material online available here yeah even America's offline be available her books may secondary index topics you have a hundred percent clear knee Ottawa Z so is remember both he bought the bill cool basic level start karo the key our kupuna topic portable cool concept 100 percent clear oj2 secondary index um start can take 'his a secondary index allah got a goomar jota care time complexity care or porous in ariane discuss currently two types of indexes memory pass at a primary index clustered secondary primary or cluster key money already video now you hear Oracle linkage of hemoptysis share Karuna description box may Yahoo p.m. start Korea secondary index - Jessica Nam being a second second second comma klava doosra key already database make index laga we're up to a core index banana a biscuit reason care movie of koopa vato sub sep an item secondary index of laga theme secondary index in a cottage of data hemara an ordered a always remember job data hemara unordered have many types of indexes make table chair key aware of who stable say we check receptive job date Amira an ottoman Club sorted in a year though who skates Miam concerned excelling at a secondary though whose case we were posed okay Svante a further Kioto data key here yeah data non key to Ogawa bath gross secondary index tone Kuna got a second job already ache index laga were Tokyo Malaga Thea Jessica Manohar discriminated on our employer employee ID employee name let's say pan number but data to have already sorted on the basis of employee ID because employee ID act primary key here to Yaniv okay i have key value a much-loved unique and unique be here or not null be a or AWS data co already sought key aware on the basis of employee ID UK most of the such Ciotti a key find the name of the employee disk employee ID AI find the detail of the employee whose employee IDs 10 find the address find the means find the detail of the employee whose employee ID is this much-loved Sarika sorry query agar employee ID k base PR here so op k I use kuru primary index use guru primary index which is always pass Buki I gave you that that is also known as primary index so here index mid already Nagaraju paquimé and you carry employee ID employee ID k base webinar a lick in Khyber chaotic Egypt queries abuser job query liquor too most of the timeto user a measure employee ID key base Fela Giga Yeager my student a table key bath crew - student career Tom Casas search carrying a registration number here roll number c ir city seem a train key information Casas search cart a train k number six like incoherent ke baare hamare pass search correctly a couch or column Kiba Yuto / JD Jessy agar my employ named Caillou's guru he find that detail of the employee whose name is wrong you find the detail of the employee whose pan card number is this case may primary index for fellow jaga qqp primary next Onaga employee ID Cooper or query can on the basis of employee name yeah Panther those case my primary index Samara Fei Liu ji three keys Phelan vs. push cases my fellow jaga most of the cases meto a chopper from Carrigan those cases may have used karthika secondary index the yeah hop a secondary index Jessica my navy with Agatha Cokie key a non key data unordered oka unordered comic LePage sa a b a b c d naraku is my order here but allah be happy going order being here or doosra KB or Saturn on key so Armas except allocation a round key key McClure candidate key key mclubbe candidate key yeah Faribault octo unique Java data Mara uniquor so agar many a uniquely a Penta because pan card number character unique order but here order near or lies co-op order curse at a queue queue key data already ordered I employee ID KB speak a grab nice copy order car Dianna - yes ara chiffon oh jaga the aggregation of a legato primary next fellow Jenna - primary through important hey secondary Liguori - secondary index acoustic I see what I bought this impeller pan card card data unique about order near but employee Java Miska index malaria a juvenile ha mr. index so they could index me hum hamesha sought riddling sorted index cone sorted car calf either a binary search Allah gas active bad me or binary search operation Amara time-consuming the other Amara time-saving with that though yeah happy up kiya karo is Co softly Ricardo is Co order kuru or south member past pointers pointers leaky knee up a question gotta keep secondary index a karmic keeping a guru key value pay Tokyo a dense Venegas pass it is always dense it is always dance QQ key up primary index key try a happy Apple and Kearney Banaszak the anchor much local leader near yes blocker agar mice block one ki baat karu this block may leader corner Cohiba Lee attorney a 23 guy got married uh no 6 feet over here marry the Rose okay Graham a leader in the sense ki corn is pure block o represent Korsak the koi vinegars actor yuuki assorted nahi Mottola via pay he have a logic assorted name forty fifty one sixty two thirty three this block is not sorted to you happy mana Katya who sorted form a ligardi 23 represent Kara 33:42 heard record Kelly database may her record Kelly a eight pointer banana padega who is co home both their dance to total number of Records Keith neo Jangi index me number of Records kita nihongi Jacana number of records a hard disk and the g3 number of my appeal ignatow number of records in index is always equal to number of records in hardness in hardness w move is called their dance - yeah - cello solve obeah dance a Garamba are a key key base B second index raga remember are a paella card Kaiba speak a pan card kbsp mana mana to Veera given you the complexity keoki log n log n where n is the number of blocks where n is the number of blocks in a index table and is the number of blocks index women plus 1 plus 1 q QP yaha see of course it affect page number milega will page numbering a block number of post block be like a jogger fear of couse block or surgical care data nicola the log and +1 i'm a bucketeer agar date Amira an order - hey because our Naruto hey Nadia melayu worst case I cannot OData order or nahi data Kia Jessica yogurt my name kobato to name the co a BAC ldef like that tanaka data he ordered or nahi data a haka he much love data unique minion so is case may be concerned XLR Giga secondary like in castle a Giga a be of the ecclesia yeha Peyman a yeh jo has secondary index ERP women are oh yes secondary indexes over kiss Cooperman ro Kwanza key value use Kuro kima flop search key values you have a search console kiss key base pay name KB space search Quran so index table me up to multiple any learning a multiple beanie Laney toga can see I got my Aiko search car now let's say if I want to search a in eros Kamiya say remove curve the toe Q key is cool it's valid index table could represent Garre of Ambedkar I do say index table key jahi man named key basis people are togarmah a connect point of an ultimate Cahaba now you key a - yaha ba yaha BM multiple geography - yaja P always remember a intermediate layer bhavani intermediate layer or more intermediate layer who gotcha block of record pointers block of and record pointers cooking up a multiple even multiple a multiple be multiple see like an index favor me up cumulative and even on a multiple Blanca five Dania index be duplicated Agra co-op index move now ek aur aapke Pataki happy multiple is a so is copy kappa block Vinod oh my love is God pure I draw jaha P J block is record Co represent karai Eve Allah he is cooker ah yayyy let's say is Kokura or Jager let's say Korea - ye it's funny eco represent current or it's poor a block o con represent Cara he represent correct se be Kelly a core banana Perdita be Kelly we called block plan up a tag a block of record pointers job a would be Co represent Caraga you happy let's say Kiera or let's say her Maya happy be little - egg beocca hero or ya habibi Kelly yes - hey Joey intermediate layer vanity the up is searching Joey parabot Oh yeaa Graham about guru yoga eat dense or sparse mix agua del so sparse mix / q q KO grab intermediate on index key macro he is a country index or intermediate giveth guru year to Venegas pass to key a Kelly a plot point or bikini o'clock pointer like another Yazzie intermediate said attack ether of bath Kuro Jacob Mulenga dense Monica Q cookie become a multiple easy to her a Kelly Rocco arrow pointer of banana padega 2-year dense or sparse ignacy mix Olga - up cats up to 10 cm Yuki overall dance or sparse work at the heart of danske Java a problem to him obviously dense silica gel thing Kisco dance even a guy or it's me time too laxity time complexity yoga bath curry - diancie they could time complexity log 2 and log 2 n is koto search coming up - time lucky guy Jovie time like a hugger n number of blocks a mere a to log 2 n to iske + + y a number of block Nikita I belong concept a give itto multiple Blancos up there like a Kelly a be Kelly I see Kelly ad Kelly yebin marry past boss are a number of blocks of a pair taco 8 such yeah hosaka pathology okay ACF kapoor telugu instead of jannah - exergy servo a K and Rocco search karna padega or whoa Yakko Phil do three extra flaky jaga - a search or extra who gamma Club yaha pay time complexity Mary birthday you have a time complexity Mary buggy you keep any search of Konoha karna feel search of KU yaha karna ya Habibi m-mother one search near was a pea number of pointers made a modulo a number of pointers Mary modulo 2 is co-op log and + 2 na Monticello you save each other valet key because political log and you have a such fear it smells like the boss are a block so it's a boss sorry to call pointers or was at the end number of record point row - yaha female pass em pointers go serve chicken or Attica vulgar music value Palicki Jaya so it's my extra layer away ik layers you have o extra way so this is how we actually represent the secondary index key or non key K basis with to Yemen a key K base favor nya yeah um net non key K base paper nya - aqua puts a technique a dense Venegas past secondary index is always dense or you book a pitcher and EXO Taos con both is only secondary index Q key bouquet Agatha already who guy didn't like in bouquet peach a biack index or scepter of the book besides coffee but auto paper book a peach every other that is called a secondary index thank you

Channel: Gate Smashers

Views: 95,227

Rating: 4.9340038 out of 5

Keywords: gate, ugc net, index, secondary index, secondary index ugc net, secondary index in dbms, secondary index in sap abap, secondary index in dynamodb, secondary index in sql, secondary index and primary index, secondary index advantage, create a secondary index in sql, creating a secondary index, can secondary index be sparse, secondary index must be dense, secondary index dbms, secondary index cost

Id: Ua08uVgsk4k

Length: 13min 3sec (783 seconds)

Published: Sun Nov 11 2018