Answer / divya

No

Answer / ankush

An index creates an entry for each value that appears in
the indexed columns.

Then why it is necessary to create an index on the same
index.

as An index is a performance-tuning method of allowing
faster retrieval of records.


NO we can't create index on index.

Answer / akhilesh c

no , you can create Index on index

Answer / ramaraju

No, once we will try to create index on index we will get this error
ERROR at line 1:
ORA-01408: such column list already indexed

Answer / s.syam sundar

hi saroj,


please let me know that how can we create a index on index

usege of this kind of indexs
how it will work

thankks
syam sundar

Answer / junhua

seems IOT can do this

Answer / saroj

yes

what are different types of keys in sql?

0 Answers  

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

1 Answers   TCS,

what is sql profiler

2 Answers   Fidelity,

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers   Satyam,

Can we join tables without foreign key?

0 Answers  

Does group by remove duplicates?

0 Answers  

What is rule base and cost base optimizer?

2 Answers   Thermotech,

What is difference between stored procedures and application procedures?

0 Answers  

What is a primary key, and how is it different from a unique key?

3 Answers  

What is mutating sql table?

0 Answers  

how to saw triggers output in pl/sql database?

1 Answers  

How subquery works in sql?

0 Answers