Post reply

Schemabinding View

  • February 11, 2013 at 8:38 am

    #289254

    Created a view with schemabinding, and then created index on it...

    Question - before data loading is it necessary to drop the view or if i drop the index on this view will that do???

  • February 11, 2013 at 9:14 am

    #1586635

    saxena200 (2/11/2013)

    Created a view with schemabinding, and then created index on it...

    Question - before data loading is it necessary to drop the view or if i drop the index on this view will that do???

    unless you are loading lots of rows, and are worried about a performance impact, there's no need to do anything as far as add/deleting/updating rows...the index will become fragmented a bit just like regular indexes,and you'll need to rebuild them now and then. if you disable it and re-enable it after the data load, the index will get updated then, instead of during the process.

    the schemabinding prevents any DDL changes to the underlying objects...no new columns, or stuff like that, unless they also handle the drop/create of your view that is schemabound.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply