Section 25.4.3.7, “Defining SQL and Other API Nodes in an NDB Cluster” Section 27.1, “Defining Stored Programs” Section 17.17.2, “Enabling InnoDB Monitors” Section 14.13, “Encryption and Compression Functions” Section 8.1.2.1, “End-User Guidelines for Password Security” Section 5.2, “...
addFunction(QueryFunction, SemanticView, Locale) - Method in class com.endeca.portal.data.QueryState Add a specified QueryFunction to this QueryState, checking for duplicate multi select attribute refinements and override any single select attribute refinements The attribute keys in the QueryFunctions ...
A view is nothing but a stored query, if you are going to create an index on it, then the index is going to use that query and execute it on that table, in this case you have to make sure that the table does not change underneath. Thus by enforcing this constraint SQL Server makes...
embedded SQL examples insert of no rows cause of INSERT statement column list example INTO clause using host arrays using the SQLERRD(3) field VALUES clause inserting, rows into tables and views INTEGER datatype interface native XA internal datatype CHAR DATE definition descriptions LONG LO...
The following works on SQL Server 2014/2016 as well as any Microsoft Azure SQL Database. Produces a comprehensive result set that is easily exportable to Notepad/Excel for slicing and dicing and includes: Table Name Index Name Index Description Indexed Columns - In order Included Columns - In ...
This base interface exposes metadata for a business object and business object group. IBoolean - Interface in com.sapportals.connector.metadata.primitives This base interface exposes metadata for the boolean data primitive IBrandingImporter - Interface in com.sap.portal.resource.repository.branding Import...
Section 1.6.1, “MySQL Extensions to Standard SQL” Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files” Section 4.5.4, “mysqldump — A Database Backup Program” Section 16.1.6.3, “Replica Server Options and Variables” Section 1.3, “What Is New in MySQL 5.7”ALTER...
ROW and LIST comparisons ROW constructor SELECT Supported casts database state SQLCODE SQLERRORTEXT SQLNATIVEERROR SQLSTATE datetime CURRENT_DATE CURRENT_GMTDATE CURRENT_GMTTIME CURRENT_GMTTIMESTAMP CURRENT_TIME CURRENT_TIMESTAMP EXTRACT LOCAL_TIMEZONE field ASBITSTREAM BITST...
To see which indexes the query optimizer uses for a specific query, in SQL Server Management Studio, on the Query menu, select Include Actual Execution Plan. Don't always equate index usage with good performance, and good performance with efficient index use. If using an index always...
These keys are stored in a structure (B-tree) that enables SQL Server to find the row or rows associated with the key values quickly and efficiently.The selection of the right indexes for a database and its workload is a complex balancing act between query speed and update cost. Narrow ...