Additional restricted views required by Teradata Visual Explain must be created in Teradata Database. Teradata Visual Explain creates restricted views from a script file. There are five versions of the script file:
- DBCXViews62.bteq; used on Teradata Database V2R6.2, V2R6.1, or V2R6.0
- DBCVXViews120.bteq; used on Teradata Database 12.00.00
- DBCVXViews123.bteq; used on Teradata Database 13.00.00 and 13.10.00
- DBCVXViews140.bteq; used on Teradata Database 14.0
- DBCVXViews141.bteq; used on Teradata Database 14.10 and higher
The script files are located in the Teradata installation folder, for example, C:\Program Files(x86)\Teradata\Client\16.00\bin\DBCVXViews141.bteq
- Open Teradata Visual Explain.
-
Select
from the menu.
The Options dialog box appears with the General tab selected.
- Select Use X views (DBC and QCD).
-
A confirmation message appears. Do one of the following:
-
Click Yes to create restricted views.
-
Click No to proceed using non-X views, and then click OK.
-