SQL Server Performance

Indexed view

Discussion in 'General DBA Questions' started by xiebo2010cx, Apr 4, 2006.

  1. xiebo2010cx Member

    "indexed view is like a clustered index",

    Can anybody here give me some ideas about the indexed views, how about the physical storage?

    Thanks
  2. smy New Member

  3. satya Moderator

  4. FrankKalis Moderator

    Not to sound harsh, but all your recent questions would have been answered if you had looked in SQL Server's online help (BOL). It's not that we are not willing to help, but such "basics" you can find out yourself. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />Ich unterstuetze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)
  5. xiebo2010cx Member

    Thank you all
  6. FrankKalis Moderator

    Hey, I think I'm having a Déjà vu. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />Ich unterstuetze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)
  7. Madhivanan Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by FrankKalis</i><br /><br />Hey, I think I'm having a Déjà vu. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />Ich unterstuetze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />What do you mean? [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  8. FrankKalis Moderator

    Check out the latest threads by xiebo2010cx and you'll see what I mean. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />Ich unterstuetze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)
  9. smy New Member

    I still don't get what you mean...
  10. Adriaan New Member

    smy, you've been posting "welcome" on a couple of threads, where xiebo2010cx had posted "Thank you all" before you.

    Not that there's anything wrong with that!
  11. FrankKalis Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><br />Not that there's anything wrong with that!<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Apart from a cheap way to increase post count. [<img src='/community/emoticons/emotion-4.gif' alt=':p' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />Ich unterstuetze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)
  12. Madhivanan Moderator

    >>smy, you've been posting "welcome" on a couple of threads, where xiebo2010cx had posted "Thank you all" before you.

    I see.

    Frank, But what does Déjà vu. mean?

    Madhivanan

    Failing to plan is Planning to fail
  13. FrankKalis Moderator

    Google is your friend. [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />Ich unterstuetze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)
  14. Madhivanan Moderator

  15. Adriaan New Member

    Not sure if I would term it inappropriate, even less subjectively inappropriate.
  16. satya Moderator

    By all means there are few number of originators who will comeback with a feedback or say atleast 'Thank you' [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
  17. smy New Member

    oh..sorry..but from here, i only post welcome when he said thank you. didnt know that the welcome becomes earlier post than the thank you at your side. but here, I viewed it as the last post for my welcome..
    hmm...will take away all my welcome
  18. xiebo2010cx Member

    Thank you all again, next time I will get some "tough" questions here, Heihei!
  19. Madhivanan Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by xiebo2010cx</i><br /><br />Thank you all again, next time I will get some "tough" questions here, Heihei!<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Thats good [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail

Share This Page