Indexes in Databases
to improve the performance of any query
index is a database object
creation of indexes Method:
Automatically
PRIMAY KEY, Unique constraint to any coulumn
MANUALLY
Creation of Index:
CREATE [UNIQUE][BITMAP] INDEX indx_name
on Table_name(column_name);
When create index:
WIDE RANGE OF VALUE IN A COLUMN
May contains large number of NULL Value.
frequently access WHERE Clause or Join
less than 2% of the rows in the table
When Not create index:
i. column not use in condition than no need to create index
ii. more than 4% of data,
iii. when table is updated very frequiently
Advantages:
Improve Performance
Disadvantages:
Extra store space
Remove the index:
Drop index index_name;
Watch video Indexes in Databases || Why Index needed in Database online, duration hours minute second in high quality that is uploaded to the channel Data Science Center 19 April 2021. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 286 times and liked it 13 visitors.