SQL Terminology

The SQL documentation uses many SQL terms. As there are many different extensions of SQL and terminology varies between organizations and countries, we have provided a small glossary of the some of the terms we use:

• Access Path
• Access Plan
• Constant Expression
• Cost
• Final Access Plan
• Index Columns
• Index Value
• Inner Join
• Internal Data Structure (‘The Referenced Table’)
• Join Order
• Outer Join
• Sub-Clause.