sql - Cluster Index for a Invoice Item Table -

I tried to read and follow, but really did not understand it.

But this should be a common example: I have an invoice table with the invoice ID as the primary key.

I have an invoice I Foriegn key

I think the cluster index I want to make an invoice ID in the table of objects is my idea process:

• 99% of the questions will be for the entire invoice and not by the invoice ITMID. Invoice ITMID is an internal mechanism for keeping track of each item.
• Not unique when it is close to unique
• It will be used in questions about

Is this the right design decision why or why No ?

The answer is very well written.

• Operators such as Beatwen,>,> =>, and lieutenant;, and & lt; =
• [...]
• Use the join clause; Usually these are the foreign key columns.