Create Tbale based on Many SubQueries

Hi

I need to create a one fact table day wise and user wise.

Format is ;

Date  user callcount  sessioncount  talkmin  pausemin

All I have caluculated using Query .But my issue is when i join all together based on date and user then it is two slow in processing.

Please help me how can I  Create a Table.

Thanks

July 3rd, 2013 2:22am

you need to put DDLs here, buddy.
Free Windows Admin Tool Kit Click here and download it now
July 3rd, 2013 2:29am

First of all, you need to supply some more information if we should have a chance to help you. At least you could post the query you have put together.

What you can do yourself, is to make sure that you have proper indexes on the tables you are using. You can look at the execution plan to see which part of the query that takes the most time and then try to optimize that. That will be a good place to start.

July 3rd, 2013 4:09am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics