Firebird allows up to 256 user-created indexes per table in version 1.5 and higher, or 64 in lower releases. However, these are theoretical limits that are governed by both page size and the actual on-disk size of the index description data on the index root page. You could not store 256 indexes in a database with a page size smaller than 16KB. On the index root page, each index needs 31 bytes for its identifier, space for descriptions of each segment (column) involved in the index, and some bytes to store a pointer to the first page of the index. Even a 16KB page may not be able to accommodate 256 indexes if there are more than a few compound indexes in the database.
To create indexes, a user must be authorized to connect to the database.
An index cannot exceed 253 bytes in total width. In reality, the number of bytes may be significantly smaller. Factors that can reduce the number of actual “slots” available to store characters include
In other words, using any character set except NONE will influence your decisions about index design—particularly whether to use composite indexes. That’s the bad news. The good news is that Firebird makes good use of single-column indexes in multi-column searches and sorts, reducing the need for many multi-column indexes that you might have experienced with another DBMS.
Firebird Related Interview Questions
|RDBMS Interview Questions||MySQL Interview Questions|
|Linux Interview Questions||Mac OS X Deployment Interview Questions|
|Windows Administration Interview Questions||Windows Server 2003 Interview Questions|
|SQL Interview Questions||NoSQL Interview Questions|
|Advanced C++ Interview Questions|
Introduction To Client/server Architecture
About Firebird Data Types
Date And Time Types
Blobs And Arrays
From Drawing Board To Database
Creating And Maintaining A Database
Firebird’s Sql Language
Expressions And Predicates
Querying Multiple Tables
Ordered And Aggregated Sets
Overview Of Firebird Transactions In
Programming With Transactions
Introduction To Firebird Programming
Developing Psql Modules
Error Handling And Events
Security In The Operating Environment
Configuration And Special Features
Interactive Sql Utility (isql)
Database Backup And Restore (gbak)
Housekeeping Tool (gfix)
Understanding The Lock Manager
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.