harsha
Uploaded by
10 SLIDES
206 VUES
100LIKES

Comprehensive Database Queries Guide

DESCRIPTION

Explore detailed queries for efficient database handling, including table access, indexing, sorting, merging, and joining in various scenarios. Enhance your SQL skills with advanced techniques.

1 / 10

Télécharger la présentation

Comprehensive Database Queries Guide

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Select Full table access Emp Ctot=37 Id=0 C=37 Id=1 Query 1 e 2

  2. Select Fast full scan index Ctot=11 Id=0 C=11 Id=1 Query 3

  3. Select Merge join Full table access Emp By index row id Dept Full scan index Dept Sort Emp Id=0 C=679 Id=1 C=3 Id=2 C=1 C=37 Id=5 C=676 Id=4 C=679 Id=3 Tabella Dept Tabella Emp Query 4

  4. Select Merge join Full table access Emp Sort Salgrade Full table access Salgr Sort Emp Id=0 C=134 Id=1 C=5 Id=2 C=2 C=37 Id=5 C=130 Id=4 C=134 Id=3 Tabella Salgrade Tabella Emp Query 5

  5. Select Merge join Full table access Emp By index row id Dept Full scan index Dept Sort Emp Id=0 C=82 Id=1 C=3 Id=2 C=1 C=37 Id=5 C=79 Id=4 C=82 Id=3 Tabella Dept Tabella Emp Query 6

  6. Select By index row id Emp Range scan index Emp Ctot=66 Id=0 C=66 Id=1 C=15 Id=2 Query 7

  7. Select Sort Nested loop Full table access Emp Unique scan index Dept Id=1 C=112 Id=0 C=37 Id=2 Id=4 C=37 Id=3 C=112 C=0 Tabella Emp Tabella Dept Query 8

  8. Select Merge join Nested loop Sort Salgrade Full table access Salgr Unique scan index Dept Full table access Emp By index row id Dept Sort Emp C=5 C=37 C=2 Id=3 Id=4 C=0 Id=0 C=334 Id=2 Id=8 C=335 Id=7 C=335 Id=1 C=1 Id=5 Id=6 C=330 Tabella Dept Tabella Salgrade Tabella Emp Query 9

  9. Select Hash join Full table access Dept Full table access Emp Tabella Dept Tabella Emp C=40 Id=0 C=40 Id=1 C=2 Id=2 C=37 Id=3 Query 10

  10. Select Hash join Full table access Salgr Full table access Emp Tabella Salgrade Tabella Emp C=40 Id=0 C=40 Id=1 C=2 Id=2 C=37 Id=3 Query 11

More Related