Why is PLAN a Reserved Word in SQL Server ?

What is the purpose of PLAN and is there and example on how to use it ? I was not able to find it in. Books Online or Google


Thanks
OcTellaAsked:
Who is Participating?
 
Chris MangusDatabase AdministratorCommented:
Because of the USE PLAN query hint.
0
 
dreadyCommented:
Because of the USE PLAN feature. You should be able to find that in BOL. Or here:

http://msdn2.microsoft.com/en-us/library/ms190788.aspx

Dready
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
David ToddSenior DBACommented:
Hi,

For SQL 2000 BOL look up hints in the index, select query hints, and select hints in Accessing and Changing Relational Data.

On the first pages is ROBUST PLAN.

Regards
  David
0
 
ursangelCommented:
USE Plan query hint hint works by accepting the query plan that you want to use in XML format as an argument. Plan forcing removes the ability of the query optimizer to adapt to changing data sizes and distributions, new indexes, and other variables.

Thats is the reason why you get 'plan' as a reserved key word in sql server
0
 
Hemantgiri S. GoswamiModerator - MSDN ForumsCommented:
Hi,
Here is the list of reserved words in SQL Server 2000, PLAN is keyword that is used in Execution PLAN,BACKUP PLAN etc. and hence it is reserved word we can not use it
http://msdn2.microsoft.com/en-us/library/Aa238507(SQL.80).aspx

HTH
Hemantgiri S. Goswami | MS SQL Server MVP
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.