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 |
What is max rowid in oracle?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What are advantages of dateset in datastage?
What are the different editions of oracle?
How to create a new table in your schema?
which statement is running fastly ie insert or delete?
What is a parameter file in oracle?
How to find no of saturdays in a month using single sql ?
how to get the index id?
what are archived logs?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
Can a Tablespace hold objects from different Schemes ?