- Home
- Firebird Tutorial
- When to Index - Firebird
When to Index - Firebird
|
|
Interview Questions
All Tutorials
Job SearchSome indexes will suggest themselves to you during the initial design period—typically for requirements that you know will need particular sortings, groupings, and evaluations. It is very good practice to be conservative about creating indexes until it becomes clear that they might be beneficial. It is a rewarding strategy to defer the creation of doubtful indexes until after a point in development where you have good samplings of typical test data and an awareness of which operations are too slow.
The benefits of deferred index design include
- Reduction of “performance fogging” that can interfere with the functional integrity testing
- Faster identification of the real sources of bottlenecks
- Avoidance of unnecessary or inefficient indexing
|
|
Firebird Related Tutorials |
|
|---|---|
| MySQL Tutorial | Linux Tutorial |
| Windows 10 Tutorial | Windows 10 Development Tutorial |
Firebird Tutorial
- Server Memory Requirements
- How To Get An Installation Kit
- Linux Kits
- Windows Kits
- Testing Your Installation
- Installing An Embedded Server
- Other Things You Need To Know
- Default Disk Locations
- Network Protocols
- Named Pipes
- Local Access
- Mixed Platforms
- A Network Address For The Server
- Hosts File
- Server Name And Path
- Configuring The Tcp/ip Port Service
- Testing The Connection With Ping
- Database-level Configuration
- Where To Set Environment Variables
- The Firebird Configuration File
- Running Firebird On Linux/unix
- Running Firebird Server On Windows
- Database Aliasing
- Administering Databases
- Introducing Isql
- Client/server Vs. File-served Databases
- Characteristics Of A Client/server Dbms
- Designing For Client/server Systems
- The Role Of The Server
- Operating System Platforms
- Examples Of Topologies
- Databases
- Firebird’s Procedure Language (psql) Programming
- Multi-database Applications
- Server Security
- Database Security
- What Is A Firebird Client?
- The Firebird Client Library
- Application Development In Firebird
- Installing Clients
- Where To Specify Data Types
- Supported Data Types
- Booleans
- Sql “dialects”
- Optional Sql-92 Delimited Identifiers
- Context Variables
- List Of Predefined Date Literals
- Columns In Firebird
- Domains
- Converting Data Types
- Changing Column And Domain Definitions
- Keywords Used For Specifying Data Type
- Operations On Number Types
- Integer Types
- Fixed-decimal (scaled) Types
- Floating-point Data Types
- Date
- Timestamp
- Time
- Date Literals
- Recognized Date/time Literal Formats
- Pre-defined Date Literals In Firebird
- Implicit Type-casting Of Date/time Literals
- Date And Time Context Variables
- Operations Using Date And Time Values
- Using Cast(..) With Date/time Types
- The Extract( ) Function
- String Essentials
- Character Sets And Collation Sequences
- Blob Types
- Array Types
- Creating A Domain
- Using A Domain In A Column Definition
- Defining A Boolean Domain
- Changing Domain Definitions
- Dropping A Domain
- The Sysdba User And Password
- What Is Data
- Designing A Database
- Schema Scripts
- Physical Storage For A Database
- About Security Access
- Creating A Database
- Single And Multi-file Databases
- Creating A Multi-file Database
- The Database Cache
- Read-only Databases
- Database Shadows
- Database “hygiene”
- Dropping A Database-delete Command
- About Firebird Tables
- Creating Tables In Firebird
- Constraints In Relational Databases
- Integrity Constraints
- Using External Files As Tables
- What Is Altering Tables Statement
- Removing (dropping) A Table
- Temporary Tables In Firebird
- Terminology In Firebird
- The Foreign Key Constraint
- Interaction Of Constraints
- Custom Action Triggers
- Lookup Tables And Your Data Model
- Reference Privileges
- Handling Other Forms Of Relationship
- “object Is In Use” Error
- Limits
- Automatic Vs. User-defined Indexes
- Query Plans
- How Indexes Can Help
- What To Index
- When to Index
- Using Create Index
- Multi-column Indexes
- Inspecting Indexes
- Altering An Index
- Dropping An Index
- Firebird And The Standards
- Sql Statements
- Sql Dialects
- Sets Of Data
- Privileges-grant And Revoke
- The Select Statement
- The Insert Statement
- The Update Statement
- The Delete Statement
- The Execute Statement
- Queries That Call Stored Procedures
- Using Parameters
- Batch Operations
- Dml Operations And State-changing Events
- Expressions
- Predicates
- Symbols Used In Expressions
- Sql Operators
- Considering Null
- Using Expressions
- Function Calls
- Multi-table Query Kinds
- Joining
- Subqueries-select Query
- The Union Operator
- Considerations For Sorting
- General Form Of Order By Clause
- The Group By Clause
- What Is A View?
- Creating Views
- Read-only And Updatable Views
- Modify A View Definition?
- Dropping A View
- Using Views In Sql
- Using Query Plans For Views
- Other Derived Tables
- The Acid Properties
- Context Of A Transaction
- Transactions And Mga
- Transaction “aging” And Statistics
- Concurrency
- Record Versions
- Locking And Lock Conflicts
- The Language Of Transactions
- Starting A Transaction
- Accessing The Transaction Id
- Progress Of A Transaction
- Nested Transactions
- The Logical Context
- Multi-database Transactions
- Pessimistic Locking
- Stored Procedures, Triggers, And Transactions
- Tips For Optimizing Transaction Behavior
- Overview Of Server Code Modules
- About Stored Procedures
- About Triggers
- Psql Language Extensions
- Internals Of The Technology
- Elements Of Procedures And Triggers
- Programming Constructs
- Executable Stored Procedures
- What Are Selectable Stored Procedures?
- Creating Stored Procedures
- Executable Procedures
- What Are The Uses Of Selectable Stored Procedures?
- Procedures For Combined Use
- Changing Stored Procedures
- Dropping Stored Procedures
- Phase, Event, And Sequence
- Phase And Event
- Status
- Creating Triggers
- Special Psql For Triggers
- Updating Other Tables
- Changing Triggers
- Dropping Triggers
- Types Of Exceptions
- Exceptions In Action
- Handling Exceptions In Firebird
- Runtime Exception Messaging
- Error Codes Listing
- Uses Of Events
- Physical Security
- Platform-based Protection
- Execution Of Arbitrary Code
- Wire Security
- Web And Other N-tier Server Applications
- Entering User Credentials
- The Sysdba User
- The Posix Hole
- The Gsec Utility
- Default Security And Access
- Sql Privileges
- Objects
- Users
- Granting Privileges
- Privileges Through Roles
- Granting The Right To Grant Privileges
- Revoking Permissions
- Revoking Grant Authority
- Security Scripts
- Comparing Superserver And Classic Server Architecture
- Parameters Of Firebird Configuration File
- Working With Embedded Server
- External Code Modules
- Configuring External Locations
- Interactive Mode
- Interactive Commands
- General Isql Commands
- Show Commands To Display Metadata
- Set Commands
- Command Mode
- Extracting Metadata
- About Gbak Files
- Running A Backup
- Running A Restore
- Using Gbak With The Firebird Service Manager
- Gbak Error Messages
- Using Gfix
- Sweeping
- Shutting Down A Database - Firebird
- Changing Database Settings
- Data Validation And Repair
- Transaction Recovery
- Shadows
- Summary Of Gfix Switches
- Firebird’s Lock Manager
- The Lock Print Utility
- Lock Configuration Settings
Installation
Network Setup
Configuring Firebird
Operating Basics
Introduction To Client/server Architecture
Firebird Server
Firebird Clients
About Firebird Data Types
Number Types
Date And Time Types
Character Types
Blobs And Arrays
Domains
From Drawing Board To Database
Creating And Maintaining A Database
Tables
Referential Integrity
Indexes
Firebird’s Sql Language
Dml Queries
Expressions And Predicates
Querying Multiple Tables
Ordered And Aggregated Sets
Views
Overview Of Firebird Transactions In
Configuring Transactions
Programming With Transactions
Introduction To Firebird Programming
Developing Psql Modules
Stored Procedures
Triggers
Error Handling And Events
Security In The Operating Environment
Server Protection
Database-level Security
Configuration And Special Features
Interactive Sql Utility (isql)
Database Backup And Restore (gbak)
Housekeeping Tool (gfix)
Understanding The Lock Manager
