can we create index on index?

Answer Posted / 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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does varchar include?

517


What are records give examples?

560


How do I run sql profiler?

584


Explain the difference between triggers and constraints?

519


What is the difference between a primary key and a clustered index?

518






Why do we use subquery?

487


What is the order of sql select?

572


Why is sql better than hql?

504


What is a heap in sql?

526


Why is sql*loader direct path so fast?

595


How do temporal tables work?

514


How do I pipe the output of one isql to another?

530


mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

559


What is trigger and how to use it in sql?

536


What is sqlexception in java?

546