Indexing is the de facto optimization standard for databases. It is a very powerful and effective tool that can help speed up the retrieval of records. Without indexing, a table is scanned entirely to retrieve a particular record. So, if we have a dataset with n records, the worst-case scenario is that the record we are trying to locate is the last record in that table, and thus we need to search through n records in order to reach it. Imagine a feature class with a million features, and the time taken to visit each feature is 1 millisecond; this means we need 17 minutes to scan the entire dataset. Of course, the response time depends on the record you are looking for; if it is located at the beginning of the feature class, it will take less time to be located.
Learning ArcGIS Geodatabases
By :
Learning ArcGIS Geodatabases
By:
Overview of this book
Table of Contents (13 chapters)
Learning ArcGIS Geodatabases
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
Authoring Geodatabases
Working with Geodatabase Datasets
Modeling Geodatabases
Optimizing Geodatabases
Programming Geodatabases
Enterprise Geodatabases
Index
Customer Reviews