Can someone tell me how to index a column

[Manoj Chaurasia]

Hi all,

 

I am a beginner in spotfire. Can someone tell me how to index a column

 

Thanks in advance

[Manoj Chaurasia]

Thanks!

[Manoj Chaurasia]

So, how can gain the kind of performance improvement that I would get by indexing in DB world I have a table of more than 50 million rows and I want to do Sum OVER AllPrevious operation, and it takes very long time, and eventually crushes on memory overload.

[Shaun Simon]

Not really indexing in a sense of performance, but you can go to the toolbar > Insert > Calculated Columns > RowID() as [indexColumn]

[Sean Riley]

You don't index columns in Spotfire like you do in the DB world. Either the data will all be pulled into local RAM ("in-memory") which is already fast, or it will be kept in the database ("in-database") in which case you can manage your database on the database end, transparently to Spotfire.

[Sean Riley]

So doing a SUM() OVER AllPrevious() for 50 million rows is huge! That is extremely extremely intensive and you would need a monster machine for that. Can i ask what that will be used for I mean how will 50 million rows of data, and that OVER calculation actually be consumed

[Nathan Burnett]

Hi Sean - May i have more information on the behaviour that you are describing in this comment please  what are the determining factors for when spotfire chooses RAM vs Database for calculations 

 

Feel free to post any links to documentation that you think may be helpful.  thanks!