►Title:
Oracle - Creating Index | How to Oracle Index | DROP INDEX | DESCRIBE user_ind_columns


►Content:


--Create an index
CREATE INDEX emp_last_name_idx
ON employees(last_name);






--CREATE INDEX with the CREATE TABLE Statement


create table New_Emp
(
Employee_Id NUMBER(6) primary key using INDEX (
create index emp_Employee_Id_idx
ON New_EMP(employee_Id)
),
First_Name varchar2(20),
Last_Name varchar2(25),
Salary number(18,2)
);


SELECT INDEX_NAME, TABLE_NAME
FROM USER_INDEXES
WHERE TABLE_NAME = 'NEW_EMP';


--MULTIPLE COLUNM INDEX
CREATE INDEX emp_id_name_idx
ON NEw_EMP(employee_id, first_name);






--Which Columns are associated with the index
select *
from user_indexes;


DESCRIBE user_ind_columns


select *
from user_ind_columns
where INDEX_NAME='EMP_ID_NAME_IDX' and table_name ='NEW_EMP'




--Removing an Index


DROP INDEX EMP_LAST_NAME_IDX;




🔗LINKS🔗
Website: [ Ссылка ]
LinkedIn: [ Ссылка ]


►►► Find me on Social Media◄◄◄
Facebook: [ Ссылка ]


✉ Contact with me
Email: rezaice07@gmail.com


❤ Make sure you SUBSCRIBE and be the 1st one to view newly created videos!


Keys:


Oracle - Creating Index, How to Oracle Index, DROP INDEX, DESCRIBE user_ind_columns, Which Columns are associated with the index,MULTIPLE COLUNM INDEX, CREATE INDEX with the CREATE TABLE Statement

свернуть