Interested to Buy Any Domain ? << Click Here >> for more details...
What is an Index , Types od index why we are use index.
- 2 Answers
- 7907 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ravi saini
An index is a performance-tuning method of allowing faster
retrieval of records. An index creates an entry for each
value that appears in the indexed columns. By default,
Oracle creates B-tree indexes.
Create an Index
The syntax for creating a index is:
CREATE [UNIQUE] INDEX index_name
ON table_name (column1, column2, . column_n)
[ COMPUTE STATISTICS ];
UNIQUE indicates that the combination of values in the
indexed columns must be unique.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
What is count(*) from po_vendors(any table)?
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
can we get profile values in report without using user exists is it possible how?
What is sca and how is it useful?
what are the prerequisites for costing transactions?
In sequence i want to 11 and 15th values how we will write?
What is instead of trigger in where we will use?
Explain oracle apps architecture.
Do you know what is applysys in oracle application database schema, what is apps?
please send me forms, xml pulisher questions,answers
What is a flexfield? List out its types.
In oracle application how do you debug or trace errors?
Plz anybody send me Technical specification for AP Interface
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
