Very Large Databases

Performance of very large SQL Server table with millions of rows

Performance of very large sql server table with millions of rows: - I have a SQL server database - I have more than 200 tables in the database - I have one table that contains information on every row in all the tables. So this table will have millions of rows (Let us name it Bigtable) - Any data...

Oracle 9i Query Time

What would be an expected time to run a query that will extract 1.4 million records? There are two tables involved. Customer and Address. And No Condition.

Oracle 8i/9i Database Access

In the past, many privileges were granted to the PUBLIC pseudo-role in a couple of our databases with a large number of users. We created a role named XPUBLIC and moved all of the privileges to it and are now attempting to limit users to privileges they actually need. Does anyone know of a way to...

Oracle DataBase Connectivity

Hi, Gurus, I am a Oracle Db Administrator managing about 5 Gb DB on windows NT. There are approx 100 user connecting concurently from clients on Win 9x,XP And Win NT Ws. Last Day What happened one Xp Client Hung causing all to hung. The client machine was hard booted. After that any one trying to...

Starting isql*plus

Hi every one! I know that to start isql*plus in a browser, you are supposed to type something like: http://localhost:<port_number>/isqlplus Problem is, how do you determine the localhost and port number? Second, how can i use Enterprise manager to create reports about my tables in the Oracle...

Oracle 9i Designer

Do you have any opinions on the use of Designer versus a tool like Erwin or PowerDesigner in handling the following concerns: Database generation Reverse engineering Accurately representing every detail of a database Speed Use for different DB platforms Thanks for any comments.