SELECT*

Select * or SELECT alias.* are also supported, but if you have columns with non supported characters, they will not be validated, and will cause the query to misbehave.

TARGIT InMemory Database is designed for doing aggregative queries quickly.
Non Aggregative queries will run and will also continue to execute in full if you select a large number of records from them.

In our testing, tables with millions of records is not a problem, but if you pass a query that performs a SELECT * from a table with hundreds of millions records, internally it goes through the process of creating the table from scratch and columnizing it, thereby possibly running out of memory.

Note: Order By requires the relevant field/ expression as an argument rather than a column number.