What is an Index ?
Answers were Sorted based on User's Feedback
Answer / rahul
indexing a table is access stretagy. its a way to sort and
search record in the table. its a faster way of retreving
records.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / orawhiz
An Index is an optional structure associated with a table to
have direct access to rows,which can be created to increase the
performance of data retrieval. Index can be created on one
or more columns of a table.
Is This Answer Correct ? | 2 Yes | 0 No |
what is Single Byte Overhead...?
What is a initialization parameter file in oracle?
what is cartesian product?
Explain the difference between replace() and translate() functions in oracle?
How to login to the server without an instance?
definition of cluster and non-clustered index?
What do you mean by cdb and pdb in oracle 12c?
Can u make a synonym for deptno=10 only from emp table.
How to load data from external tables to regular tables?
What are the different types of modules in oracle forms?
I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!
What are temporal data types in oracle?