•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 423,654 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,095 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Oracle advertiser: Programming Forums
Views: 415 | Replies: 1
 |
•
•
Join Date: Jan 2008
Posts: 9
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
First off Im not a dba and Im fairly new to sql. These questions are probably basic SQL knowledge but here are the questions:
1. Say there are 75 million records in the database with about 100 columns. If you run a simple SELECT query with a couple where clauses, could this cause the system to "slow down" or "bog the system down"? I know hardware and usage play a part but lets just say thats not a concern.
2. How does the SELECT statement with where clauses search the database? Does it first look at the where clauses? For example: WHERE phone_number = 555555555. Does it go to the phone_number column and search ALL the phone numbers?
3. If there a more than one where clause, which where clause is processed first or are they processed simultaneously?
4. Is there a better way to search the db so these queries do not impact server performance?
Thanks for the help.
1. Say there are 75 million records in the database with about 100 columns. If you run a simple SELECT query with a couple where clauses, could this cause the system to "slow down" or "bog the system down"? I know hardware and usage play a part but lets just say thats not a concern.
2. How does the SELECT statement with where clauses search the database? Does it first look at the where clauses? For example: WHERE phone_number = 555555555. Does it go to the phone_number column and search ALL the phone numbers?
3. If there a more than one where clause, which where clause is processed first or are they processed simultaneously?
4. Is there a better way to search the db so these queries do not impact server performance?
Thanks for the help.
|
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- Counting the shortest route. (Game Development)
- compound operator proving efficiency (C++)
- Searching multiple MS SQL Tables (VB.NET)
- graphics.h with Borland C++ compiler (C++)
- Searching and Comparing strings from an XML Document (Python)
Other Threads in the Oracle Forum
- Previous Thread: Oracle sql developer 1.5 Java files
- Next Thread: Weird Inner Join query
