Interested to Buy Any Domain ? << Click Here >> for more details...
What is an Index ? How it is implemented in Oracle Database ?
- 4 Answers
- 11428 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
Index is an Oracle SQL object which we create to speed up
the query performance.
It is created automatically on those columns which contains
primary key or unique key.
We can also create the index manually by using create index
command.
Max 16 indexes can be defined per table.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What operating systems are supported by oracle database 10g xe?
How to call a stored function in oracle?
How to list all indexes in your schema?
Can we insert data in view oracle?
Why cursor variables are easier to use than cursors?
Explain mutating triggers.
20. Using a set operator, display the client number of all clients who have never placed an order.
How index is implemented in oracle database?
How to define a procedure inside another procedure?
How to get a list of all background sessions in the database?
Explain about achiever in sql?
How to speed up webrick?
What happens if the update subquery returns multiple rows?
Describe an oracle table?
