July 9, 2009 at 10:29 am
Hi,
I have indexes on my base tables and top of that I have views. The indexes on the base tales are not used by the query optimizer. I was trying to create the indexed view. The view did not allow me to create the index because it has left outer join for business purpose. Is they any way that I can create index on the view or make the use of the existing index on the base table.
Please advise.
Thanks
PAdma
July 9, 2009 at 10:38 am
May it's better not to use such index
What's the size of the offending table?
What kind of process against the offending table? e.g. scan or lookup?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 9, 2009 at 10:48 am
Please post query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2009 at 5:58 pm
the base table size are 17 gb, another one is 5 gb which is in scan
July 9, 2009 at 6:03 pm
Please provide us a sample query that might be using this structure (provide a sample of the schema too please).
Do you have clustered indexes on the underlying tables?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply