Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    1,245

    Unanswered: Mysterious Views

    I have two views in a production database that I did not create and I cannot account for. From the names used and the syntax of the views, it seems that the system (SQL Server) generated them.

    Name: _hypmv_0_5771
    Name: _hypmv_0

    The syntax crushes the entire SELECT statement (4357 characters) onto a single line of T-SQL (not something I'm usually in the habit of doing).

    I have read on kbAlertz that there was a bug in the original release of SQL server where the Index Tuning Wizard did not always remove hypothetical indices used to calculate performance improvements. I have not found anything related to hypothetical views. I do have indexed views, but none that reference these views.


    I have checked dependencies; nothing depends on these views and they, in turn, do not depend on anything else.

    Has anyone else encountered this problem? Aside from saving the definitions and then dropping them (just to see what may break), are there any suggestions for how to deal with this?

    The database is medium-large. About 25GB.

    Thanks,

    Hugh Scott

  2. #2
    Join Date
    May 2002
    Posts
    299

    Re: Mysterious Views

    Here is the article on hypothetical indexes...

    http://support.microsoft.com/?id=290414
    --
    -oj
    http://www.rac4sql.net

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •