Oracle CRM Zone

    Software ZONE

  • Oracle CRM

 
Article Author
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article.

SARGable is an adjective in SQL that means that an item can be found using an index (assuming one exists). Understanding SARGability can really impact your ability to have well-performing queries.

Incidentally – SARGable is short for Search ARGument Able.
...
Article Author
by Patrick G. Matthews

Introduction

Like other database applications, Access provides support for computing basic descriptive statistics for a data set, offering such aggregate functions as Count, Sum, Min, Max, standard deviation and variance (StDev, StDevP, Var, and VarP), and average (Avg). In addition to these typical aggregate functions, Access also offers the so-called "domain aggregate" counterparts for each of the aggregates already mentioned.

...
Article Author
by Patrick G. Matthews



All major SQL dialects allow for a Count aggregate function, and Access's native Jet SQL is no exception. As in other database platforms, Access's Count() (as well as the "domain aggregate" DCount()) function returns the number of records pertaining to a grouped result set and meeting the criteria specified in the query (in the case of Count()) or in DCount() in the third argument of the function.

...
Article Author
by Patrick G. Matthews



A common request in the various database zones at Experts Exchange involves returning a concatenated list of the various items in ColumnB for each distinct value in ColumnA from a particular table or query. For example:

I have a table that currently holds student subject enrolments with the following fields

Student_ID, Subject_ID
...
 
 
Must Read
Today | All Time
View All
 
 
Zone Advisors

Having problems asking a question? Have a general question about Experts Exchange? Let us know!

 
 
2000th Corporate Account

2000 organizations, including eBay, Ericsson, and Lockheed Martin, now work smarter with Corporate Accounts. Save over 36%!

 
 
[x]
Neglected Question
Neglected questions are any questions that either have not yet been addressed by an expert, or a solution has not been awarded, and may be eligible for bonus points (see your profile page for details).
Date Points Title Comments
1
 03/13/10 06:21 PM 40 APEX... Dynamic list 0
2
 03/09/10 04:17 AM 500 Oracle E-Biz  and CRM DB parameters 3
3
 03/08/10 07:56 PM 500 Issue with Arabic query with Oracle Toad 4
4
 12/17/09 01:37 AM 500 Oracle 9i Session Activity Query 1
5
 12/08/09 11:16 PM 500 Help with linking tables (Oracle SQL) 6
6
 11/18/09 11:51 PM 250 variable table name in SQL statement using SQLDeveloper 3
7
 11/09/09 11:20 PM 500 oracle expdp too slow in metadata export when exists domain index 2
8
 10/29/09 09:36 AM 500 supress do u want to save changes 2
9
 10/26/09 03:22 PM 500 How do I create a large xml file using Oracle 9i 4
10
 10/12/09 11:54 PM 500 how to use barcodes in oracle reports6i 3
View More Questions Awaiting Answers
 
 
 
Loading Advertisement...
ADVERTISEMENT