Describe the Index, Types of index, At what situation we
have used? Which one s better than others?
Answer / oraclem
Index is a DB object that makes data retrieval faster.Index created on column and that column is called index key.
Types of index:
1)BTREE Index
2)BITMAP index
Purpose of creating INDEX: Oracle will take more time to locate the record,to improve the performance of the quesry we have to create the Index.
IF we do not mention the type of index,by default oracle will take BTREE as default Index.
Is This Answer Correct ? | 1 Yes | 0 No |
what is the use of double ampersand (&&) in sql queries?
Why are cursors used?
I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?
What is a temporal data type?
what is organisational index?
What is the purpose of the sql select top clause?
Is record in pl sql?
What are transaction and its controls?
Which operator is used in query for pattern matching?
Is sql better than access?
if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?
. have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST ACC a dv b fg b bh c mk c cl c so result:- A B c dv fg mk bh cl so