| uncorrelated subqueries: about | Correlated subqueries |
| underlying assumptions: optimizer | Underlying assumptions |
| understanding complex outer joins | Understanding complex outer joins |
| understanding group by | Understanding GROUP BY |
| union all: query execution algorithms | Union all |
| UNION operation: combining queries | Performing set operations on query results with UNION, INTERSECT, and EXCEPT |
| UNION operation: NULL | Set operators and NULL |
| UNION operation: rules | Rules for set operations |
| unions: query execution algorithms | Sorting and unions |
| unique keys: generating and concurrency | Primary key generation |
| unique results: limiting | Eliminating duplicate query results |
| uniqueness: enforcing with an index | Other uses for indexes |
| unknown values. about | Unknown Values: NULL |
| UNKNOWN: and NULL | Properties of NULL |
| unload database wizard: about | Rebuild tools |
| unload database wizard: using | Exporting databases |
| UNLOAD statement: about | Export tools |
| UNLOAD TABLE statement: about | Export tools |
| unloading and reloading: databases | Rebuilding a database not involved in replication Rebuilding a database involved in replication Minimizing downtime during rebuilding |
| unloading databases: about | Rebuilding databases |
| unloading databases: using | Exporting databases |
| unnecessary distinct elimination | Unnecessary DISTINCT elimination |
| unserializable transaction scheduling: effects of | Serializable schedules |
| unused indexes: Index Consultant recommendations | Understanding the recommendations |
| UPDATE statement: locking during | Locking during updates |
| UPDATE statement: using | Changing data using UPDATE |
| updates tab: Index Consultant recommendations | Understanding the recommendations |
| updating column statistics | Updating column statistics |
| upgrade database wizard: installing jConnect metadata support | Installing the jConnect metadata support to an existing database |
| upgrading databases | Rebuild file formats |
| use and appropriate page size | Use an appropriate page size |
| use bulk operations methods | Use bulk operations methods |
| use fully-qualified names for tables in procedures | Use fully-qualified names for tables in procedures |
| use indexes effectively | Use indexes effectively |
| use of work tables in query processing | Use of work tables in query processing |
| use the WITH EXPRESS CHECK option when validating tables | Use the WITH EXPRESS CHECK option when validating tables |
| user IDs: Adaptive Server Enterprise | Users and groups |
| user IDs: case sensitivity | Case sensitivity |
| user IDs: default | The user ID default |
| user-defined data types | Using domains |
| user-defined data types: CHECK constraints | Inheriting column CHECK constraints from domains |
| user-defined data types: creating | Creating domains (Sybase Central) Creating domains (SQL) |
| user-defined data types: deleting | Deleting domains |
| user-defined functions: about | Introduction to user-defined functions |
| user-defined functions: caching | Subquery and function caching |
| user-defined functions: calling | Calling user-defined functions |
| user-defined functions: creating | Creating user-defined functions |
| user-defined functions: dropping | Dropping user-defined functions |
| user-defined functions: execution permissions | Permissions to execute user-defined functions |
| user-defined functions: external functions | Calling external libraries from procedures |
| user-defined functions: parameters | Passing parameters to functions |
| users: occasionally connected | Replication and concurrency |
| uses for locks | Types of locks |
| using aggregate functions with distinct | Using aggregate functions with DISTINCT |
| using CHECK constraints on columns | Using CHECK constraints on columns |
| using CHECK constraints on tables | Using CHECK constraints on tables |
| using column defaults | Using column defaults |
| using comparison operators in the WHERE clause | Using comparison operators in the WHERE clause |
| using compound statements | Using compound statements |
| using count (*) | Using COUNT(*) |
| using cursors in procedures and triggers | Using cursors in procedures and triggers |
| using cursors on SELECT statements in procedures | Using cursors on SELECT statements in procedures |
| using domains | Using domains |
| using exception handlers in procedures and triggers | Using exception handlers in procedures and triggers |
| using FOR XML AUTO | Using FOR XML AUTO |
| using FOR XML EXPLICIT | Using FOR XML EXPLICIT |
| using FOR XML RAW | Using FOR XML RAW |
| using foreign keys to improve query performance | Using foreign keys to improve query performance |
| using group by with aggregate functions | Using GROUP BY with aggregate functions |
| using joins in delete, update, and insert statements | Using joins in delete, update, and insert statements |
| using keys to improve query performance | Using keys to improve query performance |
| using lists in the WHERE clause | Using lists in the WHERE clause |
| USING parameter value in the CREATE SERVER statement | USING parameter value in the CREATE SERVER statement |
| using primary keys to improve query performance | Using primary keys to improve query performance |
| using procedures, triggers, and batches | Using Procedures, Triggers, and Batches |
| using ranges (between and not between) in the WHERE clause | Using ranges (between and not between) in the WHERE clause |
| using remote procedure calls | Using remote procedure calls (RPCs) |
| using SELECT statements in batches | Using SELECT statements in batches |
| using subqueries | Using Subqueries |
| using subqueries in the WHERE clause | Using subqueries in the WHERE clause |
| using Sybase Central to translate stored procedures | Using Sybase Central to translate stored procedures |
| using table and column constraints | Using table and column constraints |
| using the cache to improve performance | Using the cache to improve performance |
| using the EXECUTE IMMEDIATE statement in procedures | Using the EXECUTE IMMEDIATE statement in procedures |
| using the RAISERROR statement in procedures | Using the RAISERROR statement in procedures |
| using the WHERE clause for join conditions | Using the WHERE clause for join conditions |
| using the WITH CHECK OPTION clause | Using the WITH CHECK OPTION clause |
| using transaction and isolation levels | Using Transactions and Isolation Levels |
| using transactions | Using transactions |
| using views | Using views |
| using views with Transact-SQL outer joins | Using views with Transact-SQL outer joins |
| using XML in the database | Using XML in the Database |
| UUIDs: compared to global autoincrement | The NEWID default |
| UUIDs: default column value | The NEWID default |
| UUIDs: generating | Primary key generation |