![]() |
I downloaded this Geospatial Shapefile:
21 Jun 2016
,
|
![]() |
Life often requires comprises. In a data warehouse, there's often a trade-off between providing quick response times to reporting users running complex reports, and loading tables with new up-to-date data. Adding join-indexes to a table can speed up reports, and solve redistribution problems, but do come at a cost to table updates.
22 May 2015
,
|
![]() |
Hi!. I have the following query: create multiset volatile table newTable, no log as ( SELECT so.*, pu.* FROM db.table1 so left outer join db.table2 pu on so.id = pu.id ) with data primary index(id) on commit preserve rows; Which throws the following error when run:
08 Apr 2015
| 1 comment
,
|
![]() |
Hello,
04 Feb 2015
| 7 comments
,
|
![]() |
Hi Experts
25 Dec 2014
| 3 comments
,
|
![]() |
Can a column that will be encrypted be used as part of an index?
06 Nov 2014
| 4 comments
,
|
![]() |
I discovered last night from UseTheIndexLuke that if there's an index on col1 and an often-used query uses UPPER(col1), the index will not be used because UPPER(col1) is not the same as col1. So the author recommended to use UPPER(col1) if it's an used often on the table.
22 Oct 2014
| 2 comments
,
|
![]() |
Hi,
07 Oct 2014
| 5 comments
,
|
![]() |
Hi to the performance experts among you.
23 May 2014
| 2 comments
,
|
![]() |
creating a table with item, origin, destination.
16 Jan 2014
| 4 comments
,
|
![]() |
Hi
There may be a discussion already in this forum about Hash and Join Index. Still I am creating this post because I want to clarify few queries for my own understanding.
I am creating a HASH INDEX: here the PI of the table is (emp_id)
05 Oct 2013
| 6 comments
,
|
![]() |
23 Sep 2013
| 8 comments
,
|
![]() |
Hi All,
28 Aug 2013
| 3 comments
,
|
![]() |
Hello,
08 May 2013
,
|
![]() |
Hi,
16 Jan 2013
| 2 comments
,
|
![]() |
Good Day Folks...
15 Dec 2012
| 2 comments
,
|
![]() |
Hi, Is there any way to partition directly on a small (ie. CHAR(3)) character column, without defining a CASE_N or RANGE_N for the column (ie. partition on all unique values of the column)?
04 Oct 2011
| 1 comment
,
|
![]() |
I am relatively new to using geo functions but I want to make sure my places dimension table does not have any duplicates by doing a delta operation from the freshly geocoded records in my staging table. First, I attempted to do a left outer join on the point_geo column:
08 Sep 2011
,
|
![]() |
|
![]() |
Hi, I need to get the following information of all table indices of a table with the JDBC 'getIndexInfo()' method - The index number The first 4 are returned nicely by the 'getIndexInfo()' method. But I'cant see any information returned by the 'getIndexInfo()' method that
17 Mar 2011
| 1 comment
,
|
![]() |
Can any one tell me what is the difference between key and index? what is the difference between primary key and unique primary key? Thanks
17 Feb 2011
| 4 comments
,
|
![]() |
|
![]() |
I have a table that resolves the M-M relationship between my member and postal address tables. Member table has UPI on mbr_key. Postal Address has UPI on postal_addr_key. What's the best indexing scheme for the xref? Right now it has a NUPI on mbr_key. Would a composite on mbr_key + postal_addr_key help the join to BOTH parent tables? I think probably no, but what is the best? Most queries will need all 3 tables and will be driven from the member side (wanting to find one of the addresses associated with the members identified in the member filter condition(s)).
10 May 2010
| 1 comment
,
|