View

View are slow

That is just not true. A view is nothing more than a stored query. If the stored query text is slow, sure the view (or query against the view) will be slow. A view cannot be any slower than the query itself. When you use the specific query as defined by the view in straight SQL, you'll see the same performance.

  • Bookmark "View" at del.icio.us
  • Bookmark "View" at Digg
  • Bookmark "View" at Ask
  • Bookmark "View" at Google
  • Bookmark "View" at StumbleUpon
  • Bookmark "View" at Technorati
  • Bookmark "View" at Live Bookmarks
  • Bookmark "View" at Yahoo! Myweb
  • Bookmark "View" at Facebook
  • Bookmark "View" at Yahoo! Bookmarks
  • Bookmark "View" at Twitter
  • Bookmark "View" at myAOL
 
language/sql/oracle_db_view.txt · Last modified: 2009/03/16 15:28 by gerardnico