Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


can we create index on index?

Answers were Sorted based on User's Feedback



can we create index on index?..

Answer / divya

No

Is This Answer Correct ?    5 Yes 1 No

can we create index on index?..

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.

Is This Answer Correct ?    3 Yes 0 No

can we create index on index?..

Answer / akhilesh c

no , you can create Index on index

Is This Answer Correct ?    1 Yes 1 No

can we 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

Is This Answer Correct ?    0 Yes 0 No

can we create index on index?..

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

Is This Answer Correct ?    2 Yes 3 No

can we create index on index?..

Answer / junhua

seems IOT can do this

Is This Answer Correct ?    1 Yes 5 No

can we create index on index?..

Answer / saroj

yes

Is This Answer Correct ?    4 Yes 9 No

Post New Answer

More SQL PLSQL Interview Questions

What are the advantages of normalization?

0 Answers  


What are the new features in Oracle 10g. Compared to Oracle 9i?

1 Answers   Polaris,


How can a pl sql block be executed?

0 Answers  


what is top in tsql? : Transact sql

0 Answers  


in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 Answers  


Does inner join remove duplicates?

0 Answers  


Is sql a backend language?

0 Answers  


what is a stored procedure? : Sql dba

0 Answers  


declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,


Difference between aggregate function and analytical function?

3 Answers   Metric Stream,


Can we insert data into materialized view?

0 Answers  


What is a database event trigger?

0 Answers  


Categories