Matches in SemOpenAlex for { <https://semopenalex.org/work/W576474080> ?p ?o ?g. }
Showing items 1 to 65 of
65
with 100 items per page.
- W576474080 abstract "Acknowledgments. 1. About This Book. Intended Audience Benefits of Using This Book. How to Use This Book. How to Use the Examples. Setting Up An Optimization Test Environment. Steps to follow before testing. Steps to follow during testing. Steps to follow after testing. 2. Creating a Well-Designed Database. Introduction. Relational Database Design Concepts. Normalization. When not to normalize Constraints. Indexing Strategies. Introduction. Primary keys. Filter columns. Join columns. Unique versus non-unique. Character versus numeric. Composite index issues. Avoiding highly duplicate indexes. Clustered indexes. Sort columns. Excess indexing. Index fill factor. Index location. Differences in Database Design between OnLine and SE. Introduction. BLOBs. VARCHAR. Rowid. Understanding the Informix Optimizer. Introduction. What is an optimizer? Optimizer features and algorithms. Optimizer diagnostics. Update statistics. Programming considerations. 3. Optimizing Application Code. Introduction. SQL Tips. Numeric versus non-numeric joins and filters. Substring searches. Temporary tables. Subqueries. Cost of views. Using math inside SQL Unions. Sorting General Tips. Transactions. Error checking. Cursors. Reducing traffic between client process and server process. Concurrency. Miscellaneous tips. SQL Specific Tips. General language tips. Forms tips. Report writer tips. ESQL/C Specific Tips. Memory management. Informix string-handling functions. Dynamic SQL. Dynamic SQL without system descriptor area or SQLDA. Process control. Compilation hints. Stored procedures, triggers, and cascading deletes. Stored procedures. Client/Server Security. Triggers. Cascading deletes. Distributed system considerations. Assessing your network's capabilities. Minimizing network traffic. Tuning your network. 4. The Informix Engines. Introduction. Standard Engine. Specific Tips. Defragmenting database files. Transaction log. Moving tables to other devices. When to move to OnLine. Online Specific Tips. Conventions. Disk configuration. Shared memory configuration. Virtual processor configuration. Logging. Key-only reads. Setting SQL turbo priority. Parallel archiving and restoring. Advanced user monitoring. Data fragmentation and PDQ. Introduction. Fragmentation. How is fragmentation implemented? PDQ. 5. Case Studies. Introduction. Case study 1. Case study 2. Case study 3. Case study 4. Case study 5. Index." @default.
- W576474080 created "2016-06-24" @default.
- W576474080 creator A5029731559 @default.
- W576474080 date "1995-04-10" @default.
- W576474080 modified "2023-09-27" @default.
- W576474080 title "Optimizing INFORMIX applications" @default.
- W576474080 hasPublicationYear "1995" @default.
- W576474080 type Work @default.
- W576474080 sameAs 576474080 @default.
- W576474080 citedByCount "0" @default.
- W576474080 crossrefType "book" @default.
- W576474080 hasAuthorship W576474080A5029731559 @default.
- W576474080 hasConcept C154420247 @default.
- W576474080 hasConcept C164120249 @default.
- W576474080 hasConcept C194222762 @default.
- W576474080 hasConcept C199360897 @default.
- W576474080 hasConcept C23123220 @default.
- W576474080 hasConcept C2778692605 @default.
- W576474080 hasConcept C41008148 @default.
- W576474080 hasConcept C510870499 @default.
- W576474080 hasConcept C75165309 @default.
- W576474080 hasConcept C75949130 @default.
- W576474080 hasConcept C77088390 @default.
- W576474080 hasConcept C88548561 @default.
- W576474080 hasConcept C97854310 @default.
- W576474080 hasConceptScore W576474080C154420247 @default.
- W576474080 hasConceptScore W576474080C164120249 @default.
- W576474080 hasConceptScore W576474080C194222762 @default.
- W576474080 hasConceptScore W576474080C199360897 @default.
- W576474080 hasConceptScore W576474080C23123220 @default.
- W576474080 hasConceptScore W576474080C2778692605 @default.
- W576474080 hasConceptScore W576474080C41008148 @default.
- W576474080 hasConceptScore W576474080C510870499 @default.
- W576474080 hasConceptScore W576474080C75165309 @default.
- W576474080 hasConceptScore W576474080C75949130 @default.
- W576474080 hasConceptScore W576474080C77088390 @default.
- W576474080 hasConceptScore W576474080C88548561 @default.
- W576474080 hasConceptScore W576474080C97854310 @default.
- W576474080 hasLocation W5764740801 @default.
- W576474080 hasOpenAccess W576474080 @default.
- W576474080 hasPrimaryLocation W5764740801 @default.
- W576474080 hasRelatedWork W1544036676 @default.
- W576474080 hasRelatedWork W2370394751 @default.
- W576474080 hasRelatedWork W2374581806 @default.
- W576474080 hasRelatedWork W2537260709 @default.
- W576474080 hasRelatedWork W2566535651 @default.
- W576474080 hasRelatedWork W580348506 @default.
- W576474080 hasRelatedWork W100951791 @default.
- W576474080 hasRelatedWork W1514198543 @default.
- W576474080 hasRelatedWork W2165795321 @default.
- W576474080 hasRelatedWork W2814471947 @default.
- W576474080 hasRelatedWork W2862923125 @default.
- W576474080 hasRelatedWork W2874450014 @default.
- W576474080 hasRelatedWork W2931016191 @default.
- W576474080 hasRelatedWork W2933658946 @default.
- W576474080 hasRelatedWork W2940954968 @default.
- W576474080 hasRelatedWork W2960465367 @default.
- W576474080 hasRelatedWork W3019035630 @default.
- W576474080 hasRelatedWork W3132447944 @default.
- W576474080 hasRelatedWork W3153532535 @default.
- W576474080 hasRelatedWork W3182102875 @default.
- W576474080 isParatext "false" @default.
- W576474080 isRetracted "false" @default.
- W576474080 magId "576474080" @default.
- W576474080 workType "book" @default.