Advatage and disadvantage of indexes – in short


· it improves the query performance, as the query optimizer can choose from all the existing indexes to come up with an efficient execution plan


· Insert, Update and Delete operations will become very slow if there are many indexes created on a table. This occurs when the Insert, Update or a Delete operation against a table results in all the indexes being updated, reducing query performance.

· Indexes are stored on disk and the amount of space required by the index depends on the size of database table, and the number and type of columns used within the index definition.

· Index needed proper maintenance


Comment please...

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s