September 12, 2005 at 12:18 pm
Can someone explain the perfomance timings for the following situation:
01. We have a single file with more than 85 million rows.
02. Now we have created 60 partition tables with same structure
with EXTRACT_DATE as Check Constraint which is a part of
PK.
03. Renamed the Big File, created partitioned view with UNION ALL.
Now I want some statistics on the following for example:
SELECT INSERT UPDATE DELETE
Table: 1 HR (100%) 1 HR (100%) 1 HR (100%) 1 HR (100%)
View : ? ? ? ?
All of them with where clause. Can someone have any results?
Jagan
September 12, 2005 at 12:23 pm
I don't understand what you need as a result... can you rephrase that?
September 12, 2005 at 12:37 pm
I want some rough timings for all the four operations. For example if I run Select/Insert/Update.Delete Query on the original Table and if it takes 1 Hour to Run that Query. If I run all same queries aginst the partitioned view what could be the Query Timings in terms of Time and/or % of Time ie. 1 Hour.
September 12, 2005 at 12:42 pm
Run the queries and see for yourself... we can't remote perf-tune your pc from this board.
September 12, 2005 at 12:50 pm
I am only asking if there are any standard statistics available handy with the group since I am not in a position to do this testing because of time.
September 12, 2005 at 12:56 pm
OK... can't give you any. But I doubt you'll get something very usefull from other members as each server/query is unique.
September 12, 2005 at 1:23 pm
I am not able to find any link from MS website regarding any benchmark results for both SQL 2000 & 2005 Indexed Views since they are talking big about it.
September 14, 2005 at 5:06 pm
I have a similar partitioned view. It works very well if you join on the partitioning column, but doesn't help at all if you don't. Don't have any statistics since it's been awhile since it was created.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply