<div>
You should have at least a primary key in both tables and a foreign key in the fact tables to guarantee the relationship between tables.<br />
Only after that you should start think in another indexes but that's depends on your queries.
</div>


You should have at least a primary key in both tables and a foreign key in the fact tables to guarantee the relationship between tables.
Only after that you should start think in another indexes but that's depends on your queries.

<div>
Should I create separate logical index for each foreign key, or combine all foreign key within a single logical index ?<br />
<br />
Tks
</div>


Should I create separate logical index for each foreign key, or combine all foreign key within a single logical index ?

Tks

<div>
Normally you should create an index for each FK so will boost the JOIN between tables.<br />
Don't create a composite index just for saving indexes.
</div>


Normally you should create an index for each FK so will boost the JOIN between tables.
Don't create a composite index just for saving indexes.

<div>
One quick question, what's my consideration to create a composite index over &nbsp;a single index for each FK ? &nbsp;Tks
</div>


One quick question, what's my consideration to create a composite index over  a single index for each FK ?  Tks

<div>
<div class="content wysiwyg-content">
I have two tables and no index is defined. This is a data warehouse tables that will be loaded into MS AS Cube.<br />
<br />
DIM_CURRENCY (CURRENCY_IDX, CURRENCYCODE, NAME, SYMBOL, RATE)<br />
<br />
FACT_SALES_INVOICE (CURRENCY_IDX, REGION_COUNTRY, TRANSDATE, CUSTOMER_IDX, SALESMAN_IDX, BASEAMOUNT, QTY, INVOICENO, COMPANY)<br />
<br />
What kind of index should I create on each tables ?<br />
As there is no primary key on fact table, should I create individual index key for each attribute, or a single key combining all attributes ?<br />
<br />
Tks
</div>
</div>


I have two tables and no index is defined. This is a data warehouse tables that will be loaded into MS AS Cube.

DIM_CURRENCY (CURRENCY_IDX, CURRENCYCODE, NAME, SYMBOL, RATE)

FACT_SALES_INVOICE (CURRENCY_IDX, REGION_COUNTRY, TRANSDATE, CUSTOMER_IDX, SALESMAN_IDX, BASEAMOUNT, QTY, INVOICENO, COMPANY)

What kind of index should I create on each tables ?
As there is no primary key on fact table, should I create individual index key for each attribute, or a single key combining all attributes ?

Tks

Index on Database

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.