The use of Hints in SQL-Nested query optimization

Taniar, David; Khaw, Hui Yee; Tjioe, Haorianto Cokrowijoyo; Pardede, Eric

doi:10.1016/j.ins.2006.12.015

Cited by 8 publications

(2 citation statements)

References 27 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Optimizer doesn't need to identify the optimal plan for the query on creating a query plan for various reasons. Hints apply only to the optimization of the block of a statement in which they appear [11]. A statement block is any one of the following statements or parts of statements:  A simple SELECT, UPDATE, or DELETE statement  A parent statement or subquery of a complex statement  A part of a compound query If a compound query consisting of two component queries combined by the UNION operator has two blocks, one for each component query, then hints in the first component query apply only to its optimization, not to the optimization of the second component query.…”

Section: Sql Hintsmentioning

confidence: 99%

Implementing Semantic Query Optimization in Relational Databases

Mor¹,

Kashyap²,

Rathy³

2012

IJCA

View full text Add to dashboard Cite

Semantic query optimization is applied to relational databases using the inductive learning approach. This approach generates an alternate query using the learning framework and the algorithm. The alternate query should be semantically equivalent to original query. The semantically equivalent query generated should be less expensive than the original query. These can be implemented in SQL using the SQL hints. These hints allow user to implement the desired plan for the query.

show abstract

Section: Sql Hintsmentioning

confidence: 99%

Implementing Semantic Query Optimization in Relational Databases

Mor¹,

Kashyap²,

Rathy³

2012

IJCA

View full text Add to dashboard Cite

show abstract

“…Further research on this topic includes the issues of optimization of translated algebraic expressions [20,25], safe queries in the web scenario, and the open problem of whether a broader subclass of domain independent formulas can be recognized efficiently.…”

Section: Conclusion and Further Researchmentioning

confidence: 99%