How to index a SQL Server table which contains foreign keys?

Elastic Stack Logstash
1

I already indexed a simple SQL Table with an id and a couple of other values like name, etc.

But when it comes to indexing a table with foreign keys, im quite lost how to configure logstash.

My database is similar to this:

Table1{
id int,
userName varchar,
userNickname varchar,
idTable2 int,
idTable3 int
}

Table2{
id int,
address varchar
}

Table3{
id int,
macAdress varchar,
ipAdress varchar
}

So what's the best way to index a table which contains foreign keys? I can't be the first one trying this, or am I missing something?

I found a similar question, but there wasn't any answer it.

Thanks in advance!

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.