The physical-design tag has no wiki summary.
4
votes
1answer
65 views
How does PostgreSQL physically order new records on disk (after a cluster on primary key)?
Need to know how PostgreSQL orders records on disk. In this case, I would like to take advantage of index combination as stated in the docs, which as I understand uses bitmaps to get matching rows ...
5
votes
2answers
1k views
Separate stored procedures for inserts and updates?
I have a table in Microsoft SQL Server. Sometimes I need to update, and sometimes I need to insert. I could write 2 stored procedures:
InsertNewPerson
UpdatePertsonById
But I was thinking to write ...
2
votes
1answer
207 views
How to design tables for players in a tournament?
I need help with my database table design.
I have group which contains a list of players. In every group each player plays games with other players. Game has also some result for example 1:0 and ...
1
vote
3answers
156 views
Usefulness of a multi-attribute index
If an index has more than one attribute in it, is there any speed gained in a select statement whose where clause uses one of the attributes in the index?
For example, take a table T with an index on ...
3
votes
1answer
212 views
What is the best practice for physical deployment of data marts?
We are just starting to get into business intelligence at our company. We have some architects who are designing our data warehouse and also our data marts. They are using star schema for both ...
