Lecture - 16 Query Processing and Optimization - III
Loading...
Loading...
24,913
Loading...
57:56
Lecture - 16 Project Monitoring and Control with PERT/Costby nptelhrd53,196 views- 55:31
Lecture - 17 Transaction Processing Conceptsby nptelhrd23,844 views
- 54:46
Lecture - 17 Cache Organizationby nptelhrd27,043 views
- 56:41
Lecture - 14 Query Processing and Optimizationby nptelhrd25,105 views
- 54:58
Lecture - 6 Structured Query Language IIby nptelhrd44,221 views
- 8:56
Realita Cinta dan Rock n Roll 9/12by sijeruk107,306,292 views
- 52:21
Lecture - 16 CPU - Memory Interactionby nptelhrd24,816 views
- 57:50
Lecture - 36 Object Oriented Databasesby nptelhrd17,425 views
- 55:15
The Theory of Normalizationby ignousocis85,975 views
- 54:46
Lecture - 34 Data Mining and Knowledge Discoveryby nptelhrd39,254 views
- 53 videosSQL 2008 - Troubleshooting and Optimization
- 56:55
Lecture -15 Query Processing and Optimization IIby nptelhrd18,491 views
- 13:12
Improve SQL Server performance using profiler and tuning advisorby dnfvideo7,509 views
- 54:55
Lecture - 10 Storage Structuresby nptelhrd21,348 views
- 58:00
Lecture - 35 Data Mining and Knowledge Discovery Part IIby nptelhrd17,455 views
- 51:59
Lecture - 19 Virtual Memoryby nptelhrd25,161 views
- 57:52
Lecture - 8 Functional Dependencies and Normal Formby nptelhrd60,634 views
- 58:25
Lecture -24 Distributed Transaction Modelsby nptelhrd12,412 views
- 57:12
Lecture - 25 Basic 2-Phase and 3-phase commit protocolby nptelhrd14,278 views
- 54:00
Lecture -2 Conceptual Designsby nptelhrd44,326 views
where is lecture 17 to lecture 23 of Dr.S.Srinath
anybody help please
and thanks in advance
tnegi42 1 year ago
@mkaul78 ok 33:51 answers my question: It says there is an exception, because of view expansion that we want the select to move up beyond the view. Ok thanks!
mkaul78 2 years ago
At 29:57, you say that all possible Manager tuples are joined with all possible Dept tuples, this to me sounds like a Cartesian Cross product that would be indicated by a "X" in the internal node above Manager and Dept leaf nodes. So doesn't the join shown in the diagram, (maybe a Nested Loop Join) drastically reduce this number already? Just wondering if you can clarify.
mkaul78 2 years ago
Can you give me an example when "selection pushing" is not a good idea?
mkaul78 2 years ago