I have a question regarding Sybase IQ, a data warehousing product. I have read that it stores data on pages vertically rather than horizontally as is on normal databases. However, i'm failing to understand how this is done.
What is the real definition of a table scan? Is it when an entire page is brought into memory and scanned? Or is it when all the pages associated to a table are brought into memory? The reason I ask is because I read in the manuals that Sybase IQ never performs a table scan but a column scan at most.
Can someone please explain how the data is physically stored on an IQ page? Its really bugging me because the manuals just say the data is stored vertically which increases the speed of queries but doesn't explain or give examples on how the data is stored!