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 |
Explain enable novalidate constraint.
What are the limitations of check constraint?
Can a property clause itself be based on a property clause ?
1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.
Explain how are indexes update?
What is a package in oracle?
what are the advantages of running a database in NO archive log mode?
What is a package ? What are the advantages of package ?
What are the differences between blob and clob in oracle?
How to export data to a csv file?
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
Explain the concept of the DUAL table.