Create Index | Unique and Non Unique | Demo | PL/SQL | SQL | Oracle | Tutorial - 14 | Tamil
1. Indexes are used to retrieve the data from the database more quickly
2. If we create Primary key or unique key in one table, then by default index is created on that column
3. If we delete the index, then this will not affect table structure and data.
4. Having too many index on one table will affect the performance, because while updating the table data, the indexes also will be updated
------------------------------
Chapter:
0:00 Index introduction
0:45 Why index needed?
2:28 Index demo
5:01 Non Unique Index
7:05 Unique Index
---------------------------
SQL Oracle playlist: • SQL | Oracle
Git: https://github.com/Kirubason/SQL_Queries
sql tutorial for beginners in tamil, interview questions and answers for experienced and for freshers, sql full course, sql tutorial, sql lecture, pl/sql interview questions and answers, oracle sql tutorial, oracle interview questions and answers for experienced.
#மைக்காடெக் #micah #kirubason #கிருபாசன்