Answer / anil kumar jaiswal

the major difference you can say here is bounding.
varray is bounded but index by table is not bounded.
means in varray you can mention the limit but in index by table you cannot.

if you got with performance varray is more effective and faster than index by table.

Can we create index on primary key?

0 Answers  

---

what is the use of HASH, LIST partitions?

1 Answers   ITC Infotech,

---

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

0 Answers  

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

1 Answers  

---

how many tupples can insert in 1 second in sql

1 Answers  

---

---

what are the performance and scalability characteristics of mysql? : Sql dba

0 Answers  

---

What is union, minus and interact commands?

0 Answers  

---

What is the difference between delete and truncate commands?

0 Answers  

---

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

4 Answers   GE,

---

How do I make sql search faster?

0 Answers  

---

What is dense_rank in sql?

0 Answers  

---

Does sql full backup truncate logs?

0 Answers  

---