what is the difference between varray and table data
type..please expalain with some examples...
under what situation you will go for varray..instead of
index by table...
Answer Posted / 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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we use ddl statements in stored procedure?
How does postgresql compare to "nosql"?
what are integrity rules?
Is it important to partition hard disk?
What is the difference between joins?
How to get list of all tables from a database?
Can we rollback delete command?
What is sql catalog?
What are commit, rollback, and savepoint?
How does join work in sql?
How can use stored procedures in sql?
What is the maximum number of triggers, you can apply on a single table?
Explain lock escalation? : Transact sql
What is sqlcommand?
what are the authentication modes in sql server? How can it be changed? : Sql dba