Interviewer And Interviewee Guide

Oracle DB Optimization Interview Question:

Tell me what are the types of Indexes?

Submitted by: Administrator
Indexes can be clustered and non-clustered indexes.
Clustered index keeps all the records in the database in the order of clustered index key.
There can be only one clustered index per table.
Non-clustered indexes are stored as B-tree structure in their own storage separate from data storage in the table.
Submitted by: Administrator

Read Online Oracle DB Optimization Job Interview Questions And Answers
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.