what is Complex index. how to create it?
Answers were Sorted based on User's Feedback
Answer / reddibasha
Do you mean Composite Index?
Composite index is the index created on multiple columns of
a table. A maximum of 16 columns can be used as a composite
index. It can be created at table level only. Unique,
Primary Key and Foreign Key can be composite keys.
Ex:
Create table emp
(eno number,
ename varchar(5),
dob date,
sal number,
dno number,
Primary Key(eno, ename) -- Composite Index
);
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / naren patidar
In cluster data of two table store in one object(cluster)
that generates a index that can identify rows of both of
table..
naren
| Is This Answer Correct ? | 1 Yes | 1 No |
What are pl/sql packages?
How to avoid duplicate records in a query?
Can we insert data in view?
Explain spool.
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
What is row_number () in sql?
pl/sql testing means what ...... explain process how to find pl/sql bugs
how can we know the count/number of elements of an array? : Sql dba
What is the clause we need to add in function body to return variable?
what is the difference between myisam static and myisam dynamic? : Sql dba
How to move files from one directory to another in pl sql?
how to insert the data through views? The view is depending upon more than two tables? how to update materalized views?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)