Please enable JavaScript.
Coggle requires JavaScript to display documents.
QUERY OPTIMIZATION images (download (2) (Basic Operators (PROJECT, UNION,…
QUERY OPTIMIZATION images
Basic Operators
PROJECT
UNION
SELECT
SET DIFFERENCE
CARTESIAN PRODUCT
PROCEDURAL
DOMAIN(Set of relations)
DERIVED OPERATORS
DIVISION
JOIN
SET INTTERSECTION
QUERYING
OPTIMIZATION
EVALUTAION
PARSING AND TRANSLATION
RETRIVING TUPLES
ACCESS PATHS
FILE SCAN
INDEX+SELECTION CONDITION
QUERY(SELECTIONSTATEMENTS)
USING INDEXES
IMPLEMENTING SELECTION OPERATOR
NO INDEX BUT THE FILE IS SORTED ON SOME ATTRIBUTES
COST OF BINARY SEARCH +COST OF RETREIVING TUPLE
A B+ INDEX IS AVAILABLE
NO INDEX AVAILABLE AND PHYSICAL FILE IS UNSORTED
THE COST IS M I/OS(M is Number of Pages In A Relation)
A HASH INDEX IS AVAILABLE
