Answer Posted / sohail
Two types of optimization.
1.logical optimization
2.physical optimization.
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
What is the use of index in hive?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
How many tables can a sql database have?
What are the events on which a database trigger can be based?
What are all the different types of indexes?
What is pl sql block structure?
What is column?
How would you pass hints to the sql processor?
How can get second highest salary in sql?
How to know the last executed procedure?
Does postgresql run on the cloud?
Which is better cte or subquery?
What is cartesian join in sql?
Why use subqueries instead of joins?
Which data dictionary views have the information on the triggers that are available in the database?