Indexing creates a data structure that speeds up data retrieval operations.

What is indexing, and how does it improve performance?

Question Posted / hr@tgksolutions.com

1 Answers
1064 Views
I also Faced
E-Mail Answers

Indexing creates a data structure that speeds up data retrieval operations. It reduces the number of disk accesses required for queries. However, too many indexes can slow down INSERT, UPDATE, and DELETE operations.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to define default values for formal parameters?

1023

How to use "while" statements in oracle?

1298

What is pragma autonomous transaction in oracle?

1040

Can we use bind variables in oracle stored procedure?

931

What is index in Oracle?

1053

What is raw datatype?

1113

What are the different windows events activated at runtime ?

2879

Can we store images in oracle database?

987

Differentiate between translate and replace?

1079

How a database is related to tablespaces?

1015

What do you mean by group by clause?

1021

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1965

How to execute a stored program unit?

1046

Why does for update in oracle 8 cause an ora-01002 error?

981

How to test null values?

1078