What is an Index ? How it is implemented in Oracle Database ?
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
ABOUT IDENTITY?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How to return top 5 rows in oracle?
What are group functions in oracle?
How to connect ms access to oracle servers?
what is the difference between functional dependecy and multilevel dependency?
Explain drop constraint oracle?
How can you use check constraints for self referential integrity?
How to insert a record into a table?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
How to assign a tablespace to a users in oracle?
Is there a function to split a string in plsql?
How to invoke the data pump export utility?
What is truncate oracle?
What is a snapshot log?