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.

What is microsoft t sql?

0 Answers  

---

What is Materialized View? In What Scenario we Use Materialized View?

2 Answers   Dinesh, Marlabs,

---

What are the parameter modes supported by pl/sql?

0 Answers  

---

Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.

5 Answers   Thomson,

---

What are variables in pl sql?

0 Answers  

---

what is difference between procedure and function

10 Answers   MCN Solutions, Wipro,

---

What is the difference between sum and count in sql?

0 Answers  

---

What is pls integer?

0 Answers  

---

Is t sql a programming language?

0 Answers  

---

Why we use join in sql?

0 Answers  

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

0 Answers  

---

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows

8 Answers   Sonata,

---