What is an index and types of indexes. How many number of
indexes can be used per table ?
Answer Posted / naresh
index's are used to retrive the data with in the required
time.there are two types of indexes we have
1.bitmap index
2.B-tree index
| Is This Answer Correct ? | 16 Yes | 17 No |
Post New Answer View All Answers
Can we perform dml on view?
How to select unique records from a table?
Can you sum a count in sql?
What is a stored procedure in sql with example?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What are the steps for performance tuning.
Explain table and field in sql?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
Is sql database free?
What is the use of double ampersand (&&) in sql queries? Give an example
What is the difference between left join and right join?
give the syntax of grant and revoke commands? : Sql dba
What is the purpose of primary key?
What is a left inner join?
Why commit is not used in triggers?