What Are The Limitations Of The Database (size Of Columns, Number Of

1.	What Are The Limitations Of The Database (size Of Columns, Number Of Tables, Rows...)?
Answer» There is no IMPOSED limitation. Number of columns, tables, indexes, size of columns and so on is limited only by the memory. For example, a USER reported using a SELECT statement with 41 LEFT OUTER JOIN clauses on a huge database for a DATA mining application. There is no imposed limitation. Number of columns, tables, indexes, size of columns and so on is limited only by the memory. For example, a user reported using a SELECT statement with 41 LEFT OUTER JOIN clauses on a huge database for a data mining application.

What Are The Limitations Of The Database (size Of Columns, Number Of Tables, Rows...)?

Answer»

There is no IMPOSED limitation. Number of columns, tables, indexes, size of columns and so on is limited only by the memory. For example, a USER reported using a SELECT statement with 41 LEFT OUTER JOIN clauses on a huge database for a DATA mining application.

There is no imposed limitation. Number of columns, tables, indexes, size of columns and so on is limited only by the memory. For example, a user reported using a SELECT statement with 41 LEFT OUTER JOIN clauses on a huge database for a data mining application.

Discussion

No Comment Found

Related InterviewSolutions

I Need Transaction Isolation Levels Beyond Read-committed?
The Size Of The .data File Grows In Operation Although The Total Row Count For Cached Tables Has Not Gone Up. Why?
After The Program Is Finished, There Are A Lot Statements In The *.log File. Why?
What Is The Biggest Known Hsqldb Database?
My Database Runs Out Of Memory / How Much Memory Does A Database Need?
What Are The Limitations Of The Database (size Of Columns, Number Of Tables, Rows...)?
What About Multi Threading?
How Solid Is Hsqldb When A Machine Crashes?
How Solid Is Hsqldb?
How Does Hsqldb Compare To Other Rdbms Engines In Speed?