Answer Posted / joe
View is stored query.
it have not contain data. And have not take memory.
simple,complex,materialized
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Does sql profiler affect performance?
What are some emotional triggers?
Why indexing is needed?
define join and explain different type of joins? : Sql dba
Write a query to find the names of users that begin with "um" in sql?
what is a field in a database ? : Sql dba
Which one is better subquery or joins?
Why schema is used in sql?
What is the requirement of self-join?
what are different types of collation sensitivity? : Sql dba
Does mysql_real_escape_string prevent sql injection?
Can a table contain multiple foreign key’s?
How do you delete data from a table?
How can you know that statistics should be updated?
What is input buffer in sql*plus?