Statistics

Question

Post reply

Statistics

Jaganmohan Rao

Old Hand

Points: 399
More actions
September 12, 2005 at 12:18 pm

#110766

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

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

I don't understand what you need as a result... can you rephrase that?

Jaganmohan Rao Old Hand Points: 399 More actions · Answer 2

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.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

Run the queries and see for yourself... we can't remote perf-tune your pc from this board.

Jaganmohan Rao Old Hand Points: 399 More actions · Answer 4

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.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

OK... can't give you any. But I doubt you'll get something very usefull from other members as each server/query is unique.

Jaganmohan Rao Old Hand Points: 399 More actions · Answer 6

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.

suskno@saif.com SSC-Addicted Points: 434 More actions · Answer 7

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.