hi everybody,

i want 2 discus with u about some database problems and how we can solve them ?

imangin u r a programmer or a developer and u want look up for these problems.

You are required to provide a tuning solution for the following critical problem areas:
Problem Area 1: The transaction that updates a customer’s activity level is a significant problem. It is causing extremely frequent full table scans on the Sale_head table, which is significantly slowing the entire system.
Problem Area 2 Inventory staff are complaining about the performance of retrieving new sales.
Problem Area 3 Sales & Marketing staff are having problems looking up product details for customers.
Problem Area 4 Performance is poor for entering new sales into the database.
Problem Area 5 Performance is poor for entering new orders into the database.
Problem Area 6 Inventory staff are having problems updating the database when shipments of components arrive.
Problem Area 7 Finalising the monthly accounts tends to overload the system.
Problem Area 8 Changing the status of sales and orders.
Problem Area 9 Downloading assembly details.
Problem Area 10 Generating the two mail merges.

Problem Area 11 Generating the monthly product catalogue.
Problem Area 12 Generating monthly salaries.
Problem Area 13 Adding new customers.
i want ur ideas and ur discussion
Bset wishes,

im waiting for ur ideas, bcz i have a presentation and i will discus these points

WOW You waited a whole FOUR minutes!!!!

such patience; you deserve a medal!!!


Maybe you should have addressed your lack of knowledge prior to planning a presentation on something you know little about!!

Some of us have been known to get paid a goodly sum of filthy lucre to advise on, and expedite solutions to such issues.

i have a medal in sport side my teacher,

this is not the main issue dear, if u expan my knowldge bcz may be these points will be asked