A hint is an instruction passed to the optimizer through comments in an SQL statement. Hints enable you to make decisions normally made automatically by the optimizer.
Every time SQL is executed, Oracle needs to perform all the internal processing steps, so try to reduce the number of database accesses. This reduces a lot of burden on the database.
Example: If you want to fetch the data of 2 products in the PL/SQL programming language.
Contents copied from http://geekexplains.blogspot.com/2008/06/how-to-tune-sql-queries-for-better.html
Performance of the SQL queries of an application often play a big role in the overall performance of the underlying application. The response time may at times be really irritating for the end users if the application doesn’t have fine-tuned SQL queries. There are sevaral ways of tuning SQl statements, few of which are:-
Championing Indie Authors Since 2002
where you can read a little banter, find an interesting article, or read about my life
Style Conversations
Sebuah rasa yang ku kenang dalam tulisan.
Be still, sweet child for the spiders in your head will soon tire of their webs
Imagine Create Grow
Food, drinks, style, and humor
Its not what you look like or whom you like but who you are and what you do that makes you beautiful in another persons eyes ...
I Dare You to Figure Me Out
Be bright ~ Be happy ~ Be you
a blog filled with my thoughts and adventures
I messed the last two names up anyway
A Blog to Amuse, make Relate and Whatnot!
Just two teen sisters against the world. Appreciate every moment :)
Keep Shining!
J Richards of Sanford, Florida, offers visual and written commentary, poetry and quirkery.
Welcome to Kip Walkin. The site for inspired & original poetry, quotes, articles and stories....as products of Pen on Paper!
food for thought
"The inexplicable thoughts from the closet"
Flash fiction tales of humor, horror and whimsy
Outdoor adventure stories and picture truths
Everything Bits & Pieces
JESUS IS MYLIFE
Seeking Peace Within Life
"She would be half a planet away, floating in a turquoise sea, dancing by moonlight to flamenco guitar"
I live in a world of fantasy, so keep your reality away from me.
Writer. Educator. Beer Leaguer.
Sharing about authors
It contains the world best places and things.
Chinese, language, learn, speak, write, textbook, contract, beginner, advanced, intermediate, commercial, marketing, correspondence, characters, radicals, decomposition, business, numbers, numerals, contract, email correspondence, email
The Faith Defended
A small attempt to gather unusual and amazing facts about elements of Nature.
All God-centered articles and blog posts from Godinterest
Sometimes the things we can't change end up changing us.
Be an example for the believers in your speech,your conduct,your love,faith and purity.
JMJ
Bringing fresh insights into societal norms is my thing
John 8:32
