Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does the IMDB support indexes like conventional RDBMS?

April 26, 2017conventional IMDb indexes RDBMS support

0

Posted

Does the IMDB support indexes like conventional RDBMS?

1 Answer

0

Posted

Yes, TimesTen supports indexes. Indexes improve the performance of queries to the database, just as they do in a RDBMS. TimesTen supports two types of indexes: Hash indexes, which are automatically created on the primary key of the table, and T-Tree indexes, which are created with the CREATE INDEX statement. T-Tree indexes are optimized for memory and provide superior performance to the B-Tree indexes provided in disk-optimized RDBMSs..