Query vs Showplan - What's the difference?
query | showplan |
A question or inquiry.
A question mark.
* Oliver Sacks, Awakenings
* 2006 , "Pip", Re: Royal Enfield motorbike - why would anyone buy one?'' (on newsgroup ''rec.motorcycles )
(computing, databases) A set of instructions passed to a database.
To ask, inquire.
To ask a question.
To question or call into doubt.
* {{quote-book, year=1963, author=(Margery Allingham), title=(The China Governess)
, chapter=20 (computing, databases) To pass a query to a database to retrieve information.
*
(internet) To send a private message to (a user on IRC).
* 2000 , "Phantom", Re: Uhm.. hi... I guess...'' (on newsgroup ''alt.support.boy-lovers )
* 2000 , "Robert Erdec", Re: Help; mIRC32; unable to resolve server arnes.si'' (on newsgroup ''alt.irc.mirc )
As nouns the difference between query and showplan
is that query is a question or inquiry while showplan is a text or graphical summary of how a query engine plans to optimize the execution of an SQL statement.As a verb query
is to ask, inquire.query
English
Alternative forms
* (archaic)Noun
(queries)- The teacher answered the student's query concerning biosynthesis.
- She had written in her diary: "I don't think I am in a concentration-camp??????", the queries growing larger and more numerous till they covered the entire page
- I refer you to your line above, where you use a query and a bang together.
- The database admin switched on query logging for debugging purposes.
Derived terms
* query language * subqueryVerb
citation, passage=The story struck the depressingly familiar note with which true stories ring in the tried ears of experienced policemen. No one queried it. It was in the classic pattern of human weakness, mean and embarrassing and sad.}}
- He parted the channel saying "SHUTUP!"... so I queried him, asking if there was something I could do.. maybe talk...
- if you know someone who is in the channel, you can query them and ask for the key.